N
Nathan D
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
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