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?
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.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
With all due respect, its not about the code...its about the code that is not there.
The code that's not there doesn't require code tags. The code that's there does.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks