August 6, 2008 at 6:16 am
I have a stored procedure that creates results like this (simplified here):
series,month,value
1,Jan,35.5
1,Feb,39.4
..etc
2,Jan,40.4
2,Feb,21.3
..etc
3,Jan,37.2
3,Feb,41.3
..etc
I'm using a line chart like a pivot, so the series groups are based on the series column, and I get a line on the chart for each series.
All the series are on the same scale, and aim at the same target (let's say 40.0)
I wanted to add a single line across the chart at 40.0
For the life of me, I can't figure out how to do that. I can add a new value of "40.0" but then this shows up on the legend as a second item for each series.
I don't want to change the stored procedure to add a bogus series (series 0) where all the values are 40.0 because then I'll get markers, etc, and it seems like more of a hack.
so I guess the question is: Is there a way to suppress this second value from the legend?
Thanks!!!
August 6, 2008 at 7:24 am
Don't know about hiding values in the legend. I'll try using the (minor) gridlines on the Y axis for this purpose - set the interval to 40, change the color to red and mayby even increase the width to highlight it.
August 6, 2008 at 7:49 am
That is a surprisingly easy solution!
The only catch is that if the interval line is red (for example) the bottom gridline on the X axis is also red (since it's technically the first line in the interval).
I'm trying to find a way around that because this is definitely the quickest / simplest solution!
August 6, 2008 at 8:18 am
This did the trick. Thanks!
August 14, 2008 at 1:46 pm
Hi there,
Can you please post the stored procedure that you used to get this data.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply