Convert Chart Line-Column to Column-Line

[George]

I am trying to convert/develop a 4series custom chart. The
first & second series to show as a line, the third/fourth
series as bars.
Can any one help.
Many Thanks

George

 

[Jon Peltier]

George -

Next time don't use the built in custom chart type, because it'll do this whenever you add data.
Here's how to make your own combination chart.

Select the data, and make a standard chart that matches the type you'll use for half the series
(e.g., a column chart). Select a series you want to change, choose Chart Type from the Chart
menu, and choose the other type (a line). These won't change when you add more series. When you
add more series, Excel will guess what type you wanted, and odds are you'll have to change some
of them using Chart Type from the Chart menu, as above.

No need to trash your current chart, though. Just change the wrong series types as I've described.

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

 

[George]

Many thanks for the advice

-----Original Message-----
George -

Next time don't use the built in custom chart type,

because it'll do this whenever you add data.

Here's how to make your own combination chart.

Select the data, and make a standard chart that matches

the type you'll use for half the series

(e.g., a column chart). Select a series you want to

change, choose Chart Type from the Chart

menu, and choose the other type (a line). These won't

change when you add more series. When you

add more series, Excel will guess what type you wanted,

and odds are you'll have to change some

of them using Chart Type from the Chart menu, as above.

No need to trash your current chart, though. Just change

the wrong series types as I've described.