| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Updating of Graphs | Charts and Charting in Excel | |||
| Updating multiple graphs in multiple worksheets at the same time | Excel Discussion (Misc queries) | |||
| automatically updating graphs based upon conditional variables | Charts and Charting in Excel | |||
| Excel graphs not updating when source data is changed | Charts and Charting in Excel | |||
| Automatically updating Graphs | Excel Worksheet Functions | |||
Linear Mode
