Update same charts in multiple sheets at once

  • Thread starter Thread starter Div
  • Start date Start date
D

Div

Hi!
I am relatively Novice in excel. I am currently working on a project where I
have same charts in multiple sheets. Each sheet is for different audience,
therefore, I can not keep them together. I want to know if there is a way to
maintain all these charts at once. my question is -
1. Update chart 1 in sheet 1 should update chart 1 in sheet 2

is it possible?
Thanks in advance
Div
 
If the data being charted is the same:
The data is on Sheet1
On Sheet2 you have formulas like =Sheet1!A1
So now both sheets (or many sheets) have the same data
Make charts as needed
When you EDIT the data in Sheet1 all the charts will update

But maybe you mean you will be ADDING new data at the bottom of the table
and want the charts to be dynamic?
 
Back
Top