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

G

Guest

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with scatter diagram excel 2007 2
How do I stop trendline from touching the y-axis? 7
xy scatter graph 0
X-Axis Appearing in Plot Area 2
How do I adjust marker spacing in Excel scatter plot? 1
Two sets of intervals on Y axis 3
XY Scatter Chart with X-axis displays the Category Name 2
Swap axes on a scatter graph 1

Top