Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    An exploding pie (2007)

    I have two columns - a list of countries and corresponding values. USA, Japan, China are fine but I would to 'group' together UK, France and Italy (as Europe) to appear as the drawn out section of a 3d (or exploded) pie.
    How can I tell Excel which countries should be grouped and used as the drawn section of the pie? Thank you, Andy.

  2. #2
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: An exploding pie (2007)

    Oops, I've managed to sort this myself by formatting each Data Point. Soz, Andy.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: An exploding pie (2007)

    Added: oops, I didn't see that you had replied to yourself.

    Do you mean that individual segments should be drawn out, or do you want the pie-in-pie chart subtype?
    Attached Images Attached Images
    • File Type: png x.png (6.2 KB, 0 views)

  4. #4
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: An exploding pie (2007)

    Hi. I am using the pie-in-pie subtype and wanted to specify which items to include in the 'sub-pie'. I discovered I could do this by formatting each data point and stating whether it should be included in the first or second plot. Andy.

Posting Permissions

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