View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Change line to bar in Line - Column graph

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" wrote in message
...
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 :-)