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?

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Div" wrote in message
...
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