December 16, 2008 at 9:16 pm
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 could'nt find a solution. Is it possible to plot such a graph in SSRS 2005 or do we need any other S/W for this?
December 18, 2008 at 12:33 am
This should really be in the Reporting Services section...
Change your chart type to a column chart, and then explicitly change each of your "normal" data Value fields to "Plot data as line" in the Appearance tab in the Edit Chart Value dialog, leaving the "vertical line" values as columns. This assumes that you have static fields in your dataset for each of these "vertical lines", with a fixed value.
Regards,
Jacob
December 25, 2008 at 7:34 pm
Jacob,
Where IS the Reporting Services section? I have been looking for one but only see SSIS section and this one.
Mike
December 25, 2008 at 7:38 pm
Sorry,
I found it at the bottom of the list of forums after "Anything that is NOT SQL" forum.
Sorry again.
Mike
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply