Updating graphs in Excel using a macro
 

aI have about 50 graphs that I need to updte in a spreadhseet. Does anyone
have a macro I can use to update them.

Updating graphs in Excel using a macro
 

You really need to give more information. Perhaps you could even use just
one graph with variables?

--
Don Guillett
SalesAid Software

"Angela R" wrote in message
...
aI have about 50 graphs that I need to updte in a spreadhseet. Does anyone
have a macro I can use to update them.

Updating graphs in Excel using a macro
 

What needs to be updated? Formats? Data Source?

Record a macro while you change one chart, then try to include the working
bits of the recorded macro into a loop:

Dim chob As ChartObject
For Each chob In ActiveSheet.ChartObjects
With chob.Chart
' working bits in here, referenced to chob.Chart rather than to
ActiveChart
End With
Next

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Angela R" wrote in message
...
aI have about 50 graphs that I need to updte in a spreadhseet. Does anyone
have a macro I can use to update them.