ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How I can use the same graph in multiple worksheets? (https://www.excelbanter.com/excel-worksheet-functions/67871-how-i-can-use-same-graph-multiple-worksheets.html)

Benedikt

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!

Benedikt

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.


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com