Hello!
I'm wondering if there's a way to have charts auto-update (both formatting and data) from one excel spreadsheet to another to eliminate the need for replication.
I have data/charts in my master excel spreadsheet. I copy the charts into a different excel spreadsheet. I modify/change the format or data of the master excel spreadsheet charts, but the charts in the new spreadsheet do not automatically update to reflect these changes in the master file. Is there a way to have them automatically update without the need for recopying/pasting all of the charts from the master document to the new one?
I've been playing around for a quite a while now and only get to the point where the data points automatically update in the new file, but the format never seems to do so... (e.g. changes to axis, adding additional trend lines, etc.)
Thank you very much for your help!
-Door
I'm wondering if there's a way to have charts auto-update (both formatting and data) from one excel spreadsheet to another to eliminate the need for replication.
I have data/charts in my master excel spreadsheet. I copy the charts into a different excel spreadsheet. I modify/change the format or data of the master excel spreadsheet charts, but the charts in the new spreadsheet do not automatically update to reflect these changes in the master file. Is there a way to have them automatically update without the need for recopying/pasting all of the charts from the master document to the new one?
I've been playing around for a quite a while now and only get to the point where the data points automatically update in the new file, but the format never seems to do so... (e.g. changes to axis, adding additional trend lines, etc.)
Thank you very much for your help!
-Door