Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
uriel78
 
Posts: n/a
Default Charting series in different sheets (summarize)

1) I've a worksheet "TEST" ( with 4 different sheets. In every sheet there
are 2 series of data (located at the same position row-column in every
sheet, i.e. L3:L203;K3K203 and N3:N203;O3:O203)
How can I plot, in a separate sheetm a summary chart of all the series
above...(organized by name of the correspondent sheet)? I wish to define a
generalized procedure as I must do it for many files...

2) As said above, I've got many files, each one is organized as worksheet
"TEST", so that there are "TEST1", "TEST2" and so on...
I wish to compare (and chart) series across two or more workheets, for the
sheets equally named (i.e. series in "sheet1" of "TEST1"..."TEST5"
worksheet). Is there a way to realized this thing...?

TIA


  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Have a look at Jon's explanation.
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Cheers
Andy

uriel78 wrote:
1) I've a worksheet "TEST" ( with 4 different sheets. In every sheet there
are 2 series of data (located at the same position row-column in every
sheet, i.e. L3:L203;K3K203 and N3:N203;O3:O203)
How can I plot, in a separate sheetm a summary chart of all the series
above...(organized by name of the correspondent sheet)? I wish to define a
generalized procedure as I must do it for many files...

2) As said above, I've got many files, each one is organized as worksheet
"TEST", so that there are "TEST1", "TEST2" and so on...
I wish to compare (and chart) series across two or more workheets, for the
sheets equally named (i.e. series in "sheet1" of "TEST1"..."TEST5"
worksheet). Is there a way to realized this thing...?

TIA



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
uriel78
 
Posts: n/a
Default

thank you, I'll try those tips!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plotting different length series in a chart Big Red Charts and Charting in Excel 2 May 5th 05 02:00 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 05:41 PM
CHARTING W/INDIRECT SERIES Ronbo Charts and Charting in Excel 3 January 3rd 05 06:17 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 12:15 PM
graphing two series on x axis Ladislav Ligart Charts and Charting in Excel 2 December 6th 04 07:50 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"