If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Number of semi-monthly periods between 2 dates | sforr | Worksheet Functions | 15 | June 16th, 2005 03:45 AM |
Fixed vs. Relative Time Periods | RDE | Running & Setting Up Queries | 2 | June 12th, 2005 02:24 AM |
Periods don't match between the PMT and NPER functions | Juan Mas | Worksheet Functions | 1 | October 3rd, 2004 08:44 PM |
Calculating absence periods in a rolling 12 months in excel | Mark | General Discussion | 3 | June 16th, 2004 07:58 PM |
How to display a chart where number of periods vary | Belinda | Charts and Charting | 3 | April 30th, 2004 04:27 PM |