VBA/Macro to change one colour in chart to another

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA/Macro to change one colour in chart to another

FAQ

Thread Tools

Display Modes

11-12-2013, 05:11 AM

lsmcal1984 lsmcal1984 is offline

Windows XP VBA/Macro to change one colour in chart to another

Office 2003

Novice

Join Date: Aug 2013

Posts: 18

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!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Office 2010, Can't change fonts colour	Myayadana	Office	0	08-22-2013 11:26 PM
VBA to immediately change the colour of a cell depending on the code placed in anothe	Phil Payne	Excel Programming	2	07-27-2013 11:04 PM
Change font colour when tasks are completed	meileetan	Project	3	09-12-2012 07:09 AM
Change Colour Theme in Word with VBA	Davidoff78	Word VBA	1	06-28-2012 05:23 PM
CHange colour of footer if a cell changes to red	OTPM	Excel	0	05-26-2011 07:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 AM.