Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Charts: want to assign fixed color for each slice
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 |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts: want to assign fixed color for each slice | Excel Discussion (Misc queries) | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |