Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add custom colors to pallet | Setting up and Configuration of Excel | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Why Excel changes colors of my charts ? | Charts and Charting in Excel | |||
custom cell pattern colors | Excel Worksheet Functions | |||
Custom Type Charts Problem | Excel Worksheet Functions |