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

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

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


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