+ Reply to Thread
Results 1 to 5 of 5

breaking down a slice of a pie chart

  1. #1
    Registered User
    Join Date
    03-13-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    27

    Question breaking down a slice of a pie chart

    hi everyone,

    i've attached a spreadsheet that has data for a list of countries. currently, CHINA is displayed as a separate slice of the pie, but i need to display it as a portion of ASIA slice. any thoughts on how to do this? please help.

    thanks for reading.


    best,

    ian

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: breaking down a slice of a pie chart

    I don't know of a way to do this just using Chart features. The quickest solution is to use shadow data to make the chart, if you want your data table to stay the way it is. Please see added sheet "Chart Data", and I have modified the chart to use that data instead. You would use the same strategy for the second chart.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-13-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: breaking down a slice of a pie chart

    thanks, but this isn't what i mean. i don't need to add CHINA to ASIA. what i need is to show that CHINA represents 4.5% of ASIA's 56.4%.

    i've attached a new file so that hopefully what i'm trying to accomplish is more clear.

    thanks, again.


    best,

    ian

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Lightbulb Re: breaking down a slice of a pie chart

    This is more of a brainstorm than a final solution but I think it's a step closer. I have created a second pie chart that is superimposed over the first. But I haven't figured out how to show the number for data value that you want, which is the percent of Asia represented by China.

    The approach is to define a new chart that calculates the percent of the entire world represented by China, then create a single slice for that. Two more slices are needed to fill out to 100% so I create a first slice of the appropriate size to place the China slice where I want it, then make the third slice to fill it out to 100%. These two slices are formatted with no fill so as to be invisible. Their data labels are also blank so they don't show up in the legend.

    Frankly I think it would be easier to include China in the first place, with calculations to subtract it from the Asia part to make the numbers work out.

    I was not able to figure out how to do this in a single chart, though Andy Pope the Chart King may know how.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: breaking down a slice of a pie chart

    Here is an improved version that provides an automatic caption for the China data point. The caption is dynamic, so any change in the percentage will be taken care of.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1