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

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

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

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/

_______

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/

_______

1. How to obtain maximum points for a set of data point

2. How to set two data sets but only keep variables in the first data set

3. Interpolating an x, y point from known x's and y's

4. pivot tables - how can i set one up with data points over time?

5. how to copy the current row the data set points to and just change one field?

6. Setting one movie clips transform point to another movie clips transform point

7. Create different data set from one data set

8. Hey 7, was it 50 million data points, or was it 500 million data points?

9. Help converting different data sets into one data set and correcting for mismatch

10. Combine data sets into one data set

11. Matching records from data set one with records from data set

12. Creating Multiple Data Sets from One Data Set

13. Task list error: data set name is missing in the data region 'data set name'

14. setting defaults for data point size, color, shadow, etc.

3 post • Page:**1** of **1**