Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benedikt
 
Posts: n/a
Default How I can use the same graph in multiple worksheets?

I want to copy worksheets in the same Excel 2003 file to change the data but
not the layout and formulas again (for several repetitions of one
experiment). Is there a function which enables a graph to use the particular
worksheet itself as data source and not the the data range on the original
worksheet (so instead of "='sheet1'!A1:A2" kind of: ='worksheet where the
graph is on'!A1:A2).

Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benedikt
 
Posts: n/a
Default Correction: How I can use the same chart in multiple worksheets?

To be more exact I was writing about the chartfunction. But I think this
problem is not only applicable on charts.
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
Line chart from multiple worksheets Paul B. Charts and Charting in Excel 2 September 21st 05 11:46 PM
Adding and Naming Multiple Worksheets Byron Excel Worksheet Functions 6 September 8th 05 02:52 AM
Update multiple worksheets Lizz45ie Excel Discussion (Misc queries) 0 May 31st 05 09:21 PM
Countif with multiple criteria and multiple worksheets JJ Excel Worksheet Functions 1 December 28th 04 06:37 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 09:54 AM.

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"