Make your stacked column chart. Copy the data for the line series,
select the chart, and use Edit menu Paste Special to add the series.
Select the new series, and go to Chart menu Chart Type to change it to
a line. Double click this new line series, and on the Axis tab, choose
Secondary. Now go to Chart menu Chart Options, and on the Axes tab,
choose the assortment of axes you need.

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


iconic83 wrote:

hi jon i can't get it to work. i've tried making a stacked column graph
and standard line graph with both sets of data... would you please
provide more details?

thanks!
peter