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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
xy scatter graph 0
How do I stop trendline from touching the y-axis? 7
lin-log-lin chart problem 2
X-Axis Appearing in Plot Area 2
XY Scatter Chart with X-axis displays the Category Name 2
xy scatter - dates off 4
How do I adjust marker spacing in Excel scatter plot? 1

Back
Top