2 sets of "y" data points with one set of "x" data points

2 sets of "y" data points with one set of "x" data points

Post by ZG91Z » Sat, 06 Oct 2007 04:48:01


I am using Excel 2003 and trying to do a model for math class comparing the
average ocean temperature to storm activity for the last 20 years. My x axis
will be the year, then I would like to overlay the two sets of data (temp &
storms). Any ideas on how to accomplish this?
--
Doug
 
 
 

2 sets of "y" data points with one set of "x" data points

Post by David Bidd » Sat, 06 Oct 2007 05:04:10

Put your years in column A from A2 downwards, leaving cell A1 blank. Put a
title for your first series such as "Average ocean temperature" in B1, with
the temperatures in B2 downwards, and similarly "Storm activity" in C1 with
numbers from C2 downwards.
Select the range from A1 to the bottom of the data in column C.
Insert/ Chart/ XY/ choose a subtype from the pictures on the right/ progress
on through the wizard.
When you've got your chart, if the values in columns B and C cover
drastically different ranges, you can select your column C series on the
chart, Format Series/ Axes/ and select a secondary Y axis.
--
David Biddulph

 
 
 

2 sets of "y" data points with one set of "x" data points

Post by Jon Peltie » Sat, 06 Oct 2007 05:04:48

Put X values into column A starting in row 2, Y1 values (temp) in column B
starting in row 2, and Y2 values (storms) in column C starting in row 2.
Leave A1 blank, but put labels in B1 and C1.

Select this range, or a single cell in the range, and start the chart
wizard, choose your chart type, and continue through the wizard. If you have
problems, post back.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://www.yqcomputer.com/
_______