ExcelBanter - View Single Post - Charts: want to assign fixed color for each slice

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

http://pubs.logicalexpressions.com/P...cle.asp?ID=390

wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html