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!!
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.
February 28th, 2011 11:24am