Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing pie chart slice colors John Charts and Charting in Excel 1 March 2nd 08 07:48 PM
Worksheet colors don't show on screen Ohbiwan Excel Worksheet Functions 2 April 10th 07 12:38 AM
Cells do not show fill colors Ricardo Excel Discussion (Misc queries) 4 January 30th 07 03:51 PM
How can I show different bar colors in the same chart? Tee Ransone Charts and Charting in Excel 2 February 11th 06 02:17 PM
How do I change the colors of each slice in a pie chart easily? GundyUrgie Charts and Charting in Excel 1 November 3rd 05 03:10 AM


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"