add line to a stacked area chart already created

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mitch - 16 Dec 2004 16:53 GMT

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?

Reply to this Message

Bernard Liengme - 16 Dec 2004 20:13 GMT

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

Signature

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

>A client emailed me a chart that is one y-axis, has 6
> series that stack on top of themselves (staked area
[quoted text clipped - 3 lines]
> need to make those new series lines linked to the
> secondary axis. Any help?

Reply to this Message

- 17 Dec 2004 17:19 GMT

Bernard,

Thanks for the help, worked like a charm

>-----Original Message-----
>Right click on the data series in the chart; from popup menu select Chart
[quoted text clipped - 13 lines]
>
>.

Reply to this Message