custom colors for pie charts

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.

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.

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.