all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Data by Row for a chart?


Data by Row for a chart? Prashant
6/2/2005 4:59:12 PM
sql server reporting services: Hi,
I have a dataset which displayes data in a row (no of documents in each month)
So, basically I get 12 columns and one row with value for each month.
I want to create a Bar Chart, but can i supply the data by row?
I have to add 12 data fields to the Bar chart currently and they all show up
in different colors because of that. Is there a way for me to drop the row as
a series (like in excel?)
Thanks,
RE: Data by Row for a chart? Prash
6/6/2005 10:00:04 AM
Hi,
Can anyone please let me know if this is possible?
Along with the (unanswered) questions posted before, i also wanted to know
if it is possible to have one series as a line chart and one series as a Bar
chart on the same graph? if yes, can someone PLEASE tell me how? THANKS


[quoted text, click to view]
Re: Data by Row for a chart? Robert Bruckner [MSFT]
6/7/2005 8:04:20 PM
If you have RS 2000 SP1 or SP2 installed, you could set the color to the
same identical value for all values (under appearance - series styles).


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Data by Row for a chart? Robert Bruckner [MSFT]
6/7/2005 8:07:01 PM
Yes, you can do that. Create your column chart. Then go to the chart
properties dialog. In the dialog go to the Data tab and edit the properties
of your trend data series. The "Edit chart value" dialog should pop up. In
this dialog go to the Appearance tab and select "Plot data as line".

You can also check this KB article: http://support.microsoft.com/kb/842422


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

AddThis Social Bookmark Button