Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use different colors to show compoents of a pie slice
I need to create a pie chart where each slice of the pie is broken down by
color. For example, if there are four pie slices, one labeled Planning, and Planning has two components to it, I need to have two colors for those components in that pie slice. In other words, if Planning is at 50%, and within Planning, you have Meetings at 40% and Documentation at 10%, I need to show that by color breakdown. Same thing if one of the slices had four components to it, I need to have four colors within that pie slce. I cannot use Pie within a Pie because some of the pie charts would have multiple slices that have more than one component. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use different colors to show compoents of a pie slice
Hi,
This page has fancy pie chart tricks. http://www.andypope.info/charts/pies.htm But you might want to consider using a stacked bar or columns chart rather than a pie. Cheers Andy stormartpro wrote: I need to create a pie chart where each slice of the pie is broken down by color. For example, if there are four pie slices, one labeled Planning, and Planning has two components to it, I need to have two colors for those components in that pie slice. In other words, if Planning is at 50%, and within Planning, you have Meetings at 40% and Documentation at 10%, I need to show that by color breakdown. Same thing if one of the slices had four components to it, I need to have four colors within that pie slce. I cannot use Pie within a Pie because some of the pie charts would have multiple slices that have more than one component. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing pie chart slice colors | Charts and Charting in Excel | |||
Worksheet colors don't show on screen | Excel Worksheet Functions | |||
Cells do not show fill colors | Excel Discussion (Misc queries) | |||
How can I show different bar colors in the same chart? | Charts and Charting in Excel | |||
How do I change the colors of each slice in a pie chart easily? | Charts and Charting in Excel |