| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to change chart name only once
I have a sheet with 3 charts, two of them are called "Chart 2" and I need to
perform via macro a change on the axis. If I do not rename one of them the macro performs only once. If I rename it does it fine, but if I run the macro twice it get stuck. That is what I did so far: ActiveSheet.ChartObjects("Chart 2").Activate ActiveSheet.ChartObjects("Chart 2").Name = "Chart 1" ActiveChart.Axes(xlValue).Select ActiveChart.Axes(xlValue).MinimumScaleIsAuto = True ActiveSheet.ChartObjects("Chart 2").Activate ActiveChart.Axes(xlValue).Select ActiveChart.Axes(xlValue).MinimumScaleIsAuto = True ActiveSheet.ChartObjects("Chart 3").Activate ActiveChart.Axes(xlValue).Select ActiveChart.Axes(xlValue).MinimumScaleIsAuto = True Please help! -- Aligi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change chart name only once | Excel Discussion (Misc queries) | |||
| Pivot chart, macro to change color | Charts and Charting in Excel | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| chart MAcro to change on activecell | Excel Discussion (Misc queries) | |||
| Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
Threaded Mode
