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 he

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.