Thread: 13 periods

Hello from Steved

I have 13 worksheets.

The heading is F5:J5
I want to capture 2 rows please
F25:J25 and F90:J90
I have 13 sheets how do I Do a chart that will get the data from all sheets.
ie sheet13, sheet12, Sheet11 and so on to Sheet1
Thankyou.

See some suggestions here:

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

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


Steved wrote:

> Hello from Steved
>
> I have 13 worksheets.
>
> The heading is F5:J5
> I want to capture 2 rows please
> F25:J25 and F90:J90
> I have 13 sheets how do I Do a chart that will get the data from all sheets.
> ie sheet13, sheet12, Sheet11 and so on to Sheet1
> Thankyou.