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.