Remember Me?

#### Menu

#1
December 22nd 04, 11:39 AM
 PeterAtLufbra Posts: n/a
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
December 22nd 04, 02:03 PM
 Bernard Liengme Posts: n/a

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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JZip Charts and Charting in Excel 4 December 8th 04 01:59 PM No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM Kevin McCartney Charts and Charting in Excel 2 December 1st 04 01:28 PM frances Charts and Charting in Excel 2 November 29th 04 08:22 PM WP Charts and Charting in Excel 1 November 28th 04 05:19 PM

All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017