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] "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,
>>