+ Reply to Thread
Results 1 to 3 of 3

Pie in pie chart with two data series?

  1. #1
    Registered User
    Join Date
    06-14-2017
    Location
    New Haven, CT
    MS-Off Ver
    2013
    Posts
    11

    Pie in pie chart with two data series?

    Hey I was wondering if I could make a pie-in-pie chart with two series, both of which add up to 100%.
    Say I have data:
    US 40%
    UK 20%
    Ger 20%
    FR 20%

    And data from different U.S regions:
    North East 25%
    South East 25%
    West 40%
    Other 10%

    I want the big pie in the chart to contain the data in the first chart and the small pie to contain the data in the small chart (so both charts would add to 100)--is that possible?

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,695

    Re: Pie in pie chart with two data series?

    Hi,

    Do you mean you want the smaller pie to be centred on top of the larger pie?

    In which case just make one smaller and locate it on top of the other and bring it to the front. To make it easier to read change the default colours of the smaller pie's segments
    Last edited by Richard Buttrey; 11-10-2018 at 02:50 PM.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,704

    Re: Pie in pie chart with two data series?

    Some examples can be found here
    http://andypope.info/charts/pies.htm
    Cheers
    Andy
    www.andypope.info

+ 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