Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Plotting of vertical lines at irregular intervals Expand / Collapse
Posted Monday, December 29, 2008 6:28 AM


Group: General Forum Members
Last Login: Tuesday, April 17, 2012 1:31 AM
Points: 11, Visits: 118
Hi All,
I had mistakenly raised this issue in the SQL server general discussion forum [Ermm] , but now I repeat it here. I have a line chart in SSRS 2005 (X & Y axes run from 0-100) and I additionally want to plot vertical lines on the x-axis to distinguish some special points on the chart. These vertical lines need to be plotted at known but irregular intervals (for example, 5,16,25,36,48,64,78). I have been trying to find a way out but couldn't find a solution. Is it possible to plot such a graph in SSRS 2005 or do we need any other S/W for this?
Thanks in advance.
Post #626539
Posted Tuesday, December 30, 2008 9:37 AM


Group: General Forum Members
Last Login: Friday, June 04, 2010 10:17 AM
Points: 191, Visits: 386
Under Chart Properties
Data Tab, in Values click Add

Edit Chart Value, Values Tab, give a name to the Series Label, e.g, Value 5
In the Value box specify =5, click OK

Return to Data Tab of Chart Properties.
Click Add in Values , Edit chart Value, Values tab, give a name to the Series Label, e.g, Value 16
In the Value box specify =16, click OK

Repeat the above steps for 25,36,48,64,78
It should work.

View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #627441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse