View Single Post
  #3   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Mitch" wrote in message
...
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?