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
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Richard_G 
Register To Reply
Bookmarks