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. |
custom colors for pie charts
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. |
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. |
All times are GMT +1. The time now is 01:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com