Some times ago, SRuiter wrote:

Recorded Macro Missing All Useful Information

Excel 2007. I just recorded a macro of me editing the bars on a bar-chart. It was a totally useless excercise as it failed to record any important info. What I got is shown here:
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartGroups(1).GapWidth = 28
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(2).Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(3).Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(4).Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.PlotArea.Select
I did a lot of formatting to each data series.

Any ideas out there?


I have exactly the same problem. If I can't record all the formatting commands, creating and manipulating diagrams with VBA is a pain. This error seems so big, that Ruiter and me can't be the only two having it. Do I oversee something obvious????

Thanks for help, or at least compassion :-)
it drives me crazy (VBA in general, but that the only easy help I can think of - recording all the format commands - is letting me down!!!)

cheers, noun ours