Microsoft Office Forums - View Single Post - [Solved] VBA/Macro to change one colour in chart to another

Thread: [Solved] VBA/Macro to change one colour in chart to another

View Single Post

Old

11-12-2013, 05:11 AM

lsmcal1984 lsmcal1984 is offline

lsmcal1984 is offline

lsmcal1984 uses Windows XP

Windows XP lsmcal1984 uses Office 2003

lsmcal1984 uses Office 2003

Office 2003

Novice

The original poster

Join Date: Aug 2013

Posts: 18

lsmcal1984 is on a distinguished road

Default

VBA/Macro to change one colour in chart to another

Dear all,

I have about 70 charts in an Excel spreadsheet that contain a line filled with RGB 55,133,70. I want to change all occurrences of this colour to RGB 51,51,51.

Does anybody know how to write this as a Macro for all graphs in the sheet?

Many thanks!

Reply With Quote