Stacked column graph
 

How do I add a data series as a line on a stacked column graph?

Stacked column graph
 

Add the series (as another column on the stack), select it, go to Chart menu
Chart Type, and choose a line type.

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


"Clare" wrote in message
...
How do I add a data series as a line on a stacked column graph?

Stacked column graph
 

I had the same question - but when I tried your suggestion it changed all
the data series into lines.

Stacked column graph
 

You need to select just the one series you want to change.

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


"Debbie" wrote in message
...

I had the same question - but when I tried your suggestion it changed all
the data series into lines.