![]() |
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. |
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 |
All times are GMT +1. The time now is 05:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com