Charting Question - Try to graph quarterly figures
Hi, I'm fairly new to SSRS and am struggling to create a graph that I need.
I basically have a view in SQL which has 1 row of calculated quarterly figures in it. It looks something like this
Q1 Q2 Q3 Q4
Row) 100 200 300 400
What I want is a line graph with 1 line with 4 points on it for the above numbers. I've tried a number of things but my main problem is as soon as I drag the Q1 value, Q2 Value, Q3 Value and Q4 Value into the Values box of the graph it keeps creating a new
series so I end up with 4 separate series on the graph. I'm using 2008 R2. Can anyone help me out?
Thanks in advance!
February 26th, 2011 7:57pm
Just a quick update I've added another column to the table which has Year in it so now its like
Year Q1 Q2 Q3 Q4
Row) 2011 100 200 300 400
I was hoping adding Year as the series might sort it but I can't get it to plot the values properly still!!
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 8:18pm