It's most likely possible to automate what you want. Turn on the macro
recorder while you edit the chart manually, examine the code, and see
how it does the tasks. Edit the code as needed to make it run more
smoothly or more flexibly.

Post back with specific questions about the code, or if you encounter
any problems.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

taco wrote:

Hello,

I have a few graphs that other users can watch.
These graphs are in a different map then were the data is in.
When the users open the graph woorbook they get a question if they should edit the graphs with the new data.
I do not want the users to get that question. Is it possible to automate the edit process?

Thanks