How do I plot an XY (scatter) graph with two Y axes?
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 |
Answer: How do I plot an XY (scatter) graph with two Y axes?
Hi Peter,
To plot an XY (scatter) graph with two Y axes in Excel 2000, you can follow these steps:
|
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 |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com