add line to a stacked area chart already created

[Mitch]

A client emailed me a chart that is one y-axis, has 6
series that stack on top of themselves (staked area
chart?). I need to add some lines to it on a secondary y-
axis. I can add the new series to a newly created
secondary axis but that data is also area-stacked. I
need to make those new series lines linked to the
secondary axis. Any help?

 

[Bernard Liengme]

Right click on the data series in the chart; from popup menu select Chart
Type. This will apply only to the selected data series. Make the type Line.
Right click line; select Format Data Series; open Axis tab and set to
Secondary Y axis

best wishes

 

[Guest]

Bernard,

Thanks for the help, worked like a charm