Plotting data from 2 tabs

[ciaran.hudson]

Is it possible to plot data from 2 tabs on one graph?

For example I have one tab with 60,000 records containing data from
1990 to 2000 and another tab containing 30,000 records from 2001 to
2007.

I have excel 2003 so am limited in the number of rows I have.

Both tabs contain data in the exact same format.

Can I plot one continious graph from 1990 to 2007?

Grouping the data onto one tab is not an option due to what I am
trying to achieve with the graph.

Regards,
Ciarán

 

[Jon Peltier]

You need more than one series in any event, because a series can contain at
most 32k points. So make the chart with the first 30k points on the one
sheet. Copy the data for the next 30k points on the sheet, select the chart,
and use paste special to add the data as a new series. Then copy the data
for the 30k points on the other sheet, select the chart, and use paste
special to add the data as a new series.

You need to create an XY chart, and provide X and Y data for all three
series. Otherwise, the second and third series will use the same category
values as the first series.

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


Is it possible to plot data from 2 tabs on one graph?

For example I have one tab with 60,000 records containing data from
1990 to 2000 and another tab containing 30,000 records from 2001 to
2007.

I have excel 2003 so am limited in the number of rows I have.

Both tabs contain data in the exact same format.

Can I plot one continious graph from 1990 to 2007?

Grouping the data onto one tab is not an option due to what I am
trying to achieve with the graph.

Regards,
Ciarán

 

[ciaran.hudson]

Thanks Jon