How do I plot an XY (scatter) graph with two Y axes?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PeterAtLufbra - 22 Dec 2004 11:39 GMT

I need to put two sets of data on one graph, with separate linear Y axes and
plotted on a common linear x axis.
The 2 axes option is for a line chart, which gives discrete data points on
the x axis, not a linear number scale like you get using XY (scatter).
I'm using Excel 2000.

Many thanks in advance.

Peter

Reply to this Message

Bernard Liengme - 22 Dec 2004 14:03 GMT

Make the XY chart with the two data series
Right click on one data series in the chart; on popup menu use Format Data
Series
Open Axis tab and check the Secondary Axis box

best wishes

Signature

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

>I need to put two sets of data on one graph, with separate linear Y axes
>and
[quoted text clipped - 6 lines]
>
> Peter

Reply to this Message