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
Ok so I've gone full circle a bit but have managed to get what I need out in terms of the graph. I've basically changed my SQL to produce the data like this
Quarter Value
Q1 100
Q2 200
Q3 300
Q4 300
This then graphs fine and I can work my data so it always appears like this.
I'd still be interested to know if its possible to graph the data as I had it in the original format though.
Thanks!
February 27th, 2011 6:36am
What you have done is right. The values to be shown within a single line on the line chart, has to come within a column in the dataset.
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 11:24am