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

http://peltiertech.com/WordPress/200...y-series-name/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"LyndseyF_UK" wrote in message
...
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.