View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default custom colors for pie charts

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" wrote in
message ...
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.