Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 22nd 04, 11:39 AM
PeterAtLufbra
 
Posts: n/a
Default 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   Report Post  
Old December 22nd 04, 02:03 PM
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill area beneath a scatter plot JZip Charts and Charting in Excel 4 December 8th 04 01:59 PM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
Barb Reinhardt: HOW TO: Plot a Team Name .... Kevin McCartney Charts and Charting in Excel 2 December 1st 04 01:28 PM
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 2 November 29th 04 08:22 PM
Named dynamic ranges, copied worksheets and graph source data 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