Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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:
__________________
I am not human. I am an Excel Wizard |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |