December 29, 2008 at 6:28 am
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.
December 30, 2008 at 9:37 am
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.
"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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply