Mass Chart Format Update

[gflory]

I have a spreadsheet with 85 charts that I would like to update. When I created the charts, I copied and renamed the first chart to create the other 84 charts. Then, different data and titles were selected.

Today, I spent 6 hours individually changing each chart to reflect a new background, color schemes, font size, etc. Surely, there is a better way.

Any advise would be greatly appreciated.

Thanks,

Greg

 

[sheetspread]

Loop through the charts with VBA (e.g. For i = 1 To ActiveSheet.ChartObjects.Count)

First turn on the macro recorder, format one chart, look at the code, and apply. It will probably help to remove the redundant excel recorder commands like .select, selection.activate, etc.