Can excel graphs be set to choose same colour i.e hols = yellow

[LyndseyF_UK]

I have a weekly task of tracking resource across a large department,
therefore numberous graphs. Is there any way to set up excel to select the
same colour for the same task i.e. Holidays always show as Yellow on each
graph. At the moment I am manually going through each graph and changing the
colour of all tasks for each individual!!

Currently using Excel 2003.

Any help will be greatly received.

 

[Andy Pope]

Hi,

See Jon's blog on a VBA solution to this problem.
http://peltiertech.com/WordPress/2008/03/03/vba-conditional-formatting-of-charts-by-series-name/

Cheers
Andy

 

[Jon Peltier]

You can use VBA procedures to format named series in the same color. I show
how in this blog post:

http://peltiertech.com/WordPress/2008/03/03/vba-conditional-formatting-of-charts-by-series-name/

- Jon

 

[ShaneDevenshire]

Hi,

If each item (holidays, what ever) have the same series number then you can
change all of them with one command in one workbook - Choose Tools, Option,
Color, and note the Chart fills colors, modify the one you don't like by
clicking it and choosing Modify, picking the new color and saying OK This
will change this color for the entire workbook.

 

[Jon_Peltier]

The new link to that conditional chart formatting article is VBA Conditional Formatting of Charts by Series Name.