Data by Row for a chart?

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,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
"Prashant" wrote:
> 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,
>|||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.
"Prashant" <Prashant@.discussions.microsoft.com> wrote in message
news:1712D9E5-284D-40CF-8E17-B5BBE3476A5C@.microsoft.com...
> 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,
>|||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.
"Prash" <Prash@.discussions.microsoft.com> wrote in message
news:C9D588CF-E695-4E62-9E49-4E4F9FEC0EAD@.microsoft.com...
> 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
>
> "Prashant" wrote:
>> 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,