Recorded Macro Missing All Useful Information

[SRuiter]

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?

[shg]

Welcome to the forum, SRuiter.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[SRuiter]

With all due respect, its not about the code...its about the code that is not there.

[shg]

The code that's not there doesn't require code tags. The code that's there does.