If the colors are always in the same relative position in the list, make a
custom chart type, and use this type for all of your pie charts:
http://peltiertech.com/Excel/ChartsH...stomTypes.html
If the colors are not always in the same position, then you could use a
macro to assign colors:
http://pubs.logicalexpressions.com/P...cle.asp?ID=390
Scroll down to "Color by Category Label" near the end of the article.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Paperback Writer" <PaperbackWriter@discussions.microsoft.com> wrote in
message news:5E4D639B-30C9-4754-B1E8-E0BD5EDA808A@microsoft.com...
> This would be helpful to know. I am confronted with a similar dilemma.
>
> "Moh" wrote:
>
>> I have a pipe chart tracking resin colors. It would be nice to assign
>> each
>> pie piece the color it represents. For instance, yellow resin has been
>> assigned a blue pie piece, blue has been assigned a purple pie piece,
>> etc. I
>> have 13 colors to track. Any help would be greatly appreciated.
Bookmarks