charts macro for a number of datasets
 

hello,
I have a worksheet with a number of datasets. The datasets are all 360 rows
long and 2 columns wide. I wanted to plot the first set of data on a chart,
then the chart should find the next set of data, plot that, then the next. So
at the end i should have One chart containing plots of all the different
datasets. It should loop around until there are no more datasets left. I
can't figure out how to do relative references for this. The data looks
something like this.
A B
1 2
2 5

etc
(360 rows later there is a gap, then the next dataset)
A B
1 10
2 8

etc

These are repeated down the sheet and also across the sheet.

Any ideas?

Thanks

charts macro for a number of datasets
 

You might be able to use this utility:

http://peltiertech.com/Excel/ChartsH...rtUtility.html

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


"Nathan D" wrote in message
...
hello,
I have a worksheet with a number of datasets. The datasets are all 360
rows
long and 2 columns wide. I wanted to plot the first set of data on a
chart,
then the chart should find the next set of data, plot that, then the next.
So
at the end i should have One chart containing plots of all the different
datasets. It should loop around until there are no more datasets left. I
can't figure out how to do relative references for this. The data looks
something like this.
A B
1 2
2 5

etc
(360 rows later there is a gap, then the next dataset)
A B
1 10
2 8

etc

These are repeated down the sheet and also across the sheet.

Any ideas?

Thanks