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 |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com