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.