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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics