Thread: How to change a bar to line in a combo chart?

I am currently using Excel & PPt 2000 and cannot figure out how to control
which rows of data are displayed as a bar or line in a combunation chart. In
PPt it combo bar/line chart defaults to the last row only as a line and in
Excel it seems to have half as a bar/ half as a line.
Any suggestions?

In the chart, select the series you want changed. Then, select Chart |
Chart Type... and pick the desired type+subtype.

When a single series is selected the chart type choice applies only to
that one series.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <27609609-A2D7-4A18-A533-6DA7A63235DB@microsoft.com>,
KimD@discussions.microsoft.com says...
> I am currently using Excel & PPt 2000 and cannot figure out how to control
> which rows of data are displayed as a bar or line in a combunation chart. In
> PPt it combo bar/line chart defaults to the last row only as a line and in
> Excel it seems to have half as a bar/ half as a line.
> Any suggestions?
>

Thanks! I thought I had done this initially, but must not have. I was
changing the entire chart type

"Tushar Mehta" wrote:

> In the chart, select the series you want changed. Then, select Chart |
> Chart Type... and pick the desired type+subtype.
>
> When a single series is selected the chart type choice applies only to
> that one series.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <27609609-A2D7-4A18-A533-6DA7A63235DB@microsoft.com>,
> KimD@discussions.microsoft.com says...
> > I am currently using Excel & PPt 2000 and cannot figure out how to control
> > which rows of data are displayed as a bar or line in a combunation chart. In
> > PPt it combo bar/line chart defaults to the last row only as a line and in
> > Excel it seems to have half as a bar/ half as a line.
> > Any suggestions?
> >
>