Charts: want to assign fixed color for each slice

[dstdst123]

Hi folks,

I am using excel 2000. Am creating two pie charts. Chart 1 contains six
people, Chart 2 contains 3 people.

Let's say the Excel default color sequence is:
Red, Blue, Yellow, Purple, Green, Pink

Chart 1 will be:
Alex Red
Billy Blue
Charles Yellow
David Purple
Edward Green
Frank Pink

Chart 2 will be:
Billy Red
Charles Blue
Frank Yellow

However, this is not what i want.

How can I assign 1 color to each person...
so that Billy is always = blue,
while Charles is always = yellow.
and Frank is always = pink.

Thanks a lot.

cheers

 

[Debra Dalgleish]

Jon Peltier has instructions at the end of his pie chart article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390