Change line to bar in Line - Column graph

[Yonke]

Hope someone can help on this one...I have 4 data series that I am trying to
plot on a Line-Column chart. I need 3 of these to be columns and one to be a
line. It is defaulting to 2 columns and 2 lines.
Does anyone know how to override that default, so I can change the one line
(basically the 3rd data series) to a column?
Thanks :-)

[Jon Peltier]

Select the series you want to change, then on the Chart menu, choose Chart
Type, and choose the new type to assign to that series.

Next time, starting from scratch, make a column chart with all four series,
then change the one to a line.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Yonke" <[email protected]> wrote in message
news:[email protected]...
> Hope someone can help on this one...I have 4 data series that I am trying
> to
> plot on a Line-Column chart. I need 3 of these to be columns and one to
> be a
> line. It is defaulting to 2 columns and 2 lines.
> Does anyone know how to override that default, so I can change the one
> line
> (basically the 3rd data series) to a column?
> Thanks :-)

[Yonke]

Thanks! I knew there had to be a way to do it!
Cheers.

"Jon Peltier" wrote:

> Select the series you want to change, then on the Chart menu, choose Chart
> Type, and choose the new type to assign to that series.
>
> Next time, starting from scratch, make a column chart with all four series,
> then change the one to a line.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "Yonke" <[email protected]> wrote in message
> news:[email protected]...
> > Hope someone can help on this one...I have 4 data series that I am trying
> > to
> > plot on a Line-Column chart. I need 3 of these to be columns and one to
> > be a
> > line. It is defaulting to 2 columns and 2 lines.
> > Does anyone know how to override that default, so I can change the one
> > line
> > (basically the 3rd data series) to a column?
> > Thanks :-)
>
>
>