I am currently using Excel 2010 under Win XP and have created a number of monthly charts. Please would someone be able to advise me if, once these charts have been created, is it possible to change the background colour of all the charts at once instead of having to do every chart manually?
Regards
Richard
Hi Richard,
With a macro
Sub ChangeChartBackgroundColour() Dim ch As Chart For Each ch In ActiveWorkbook.Charts ch.ChartArea.Interior.ColorIndex = 6 ' change color value as appropriate Next ch End Sub
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks