+ Reply to Thread
Results 1 to 11 of 11

Pie within a Pie

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Pie within a Pie

    Hi

    I am trying to create a pie within a pie but dont know how to layout the data.

    The first pie should be split into two 27% and 73%

    the 2nd pie needs to explain the 73% into the following:
    Pension Schedule 56%
    IFRS16 Correction 19%
    Incorrect Vendor Setup 13%
    Incorrect TT used 13%


    Does anyone know how please?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pie within a Pie

    Hello!
    It's a pie of a pie
    Data labels are values from cells in the table below your data.

    best regards
    Attached Files Attached Files

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Pie within a Pie

    The data labels have a option to automatically display the Percent, no need to get values from cells.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Pie within a Pie

    Hi,

    I am unsure that gives me what I need. Maybe I haven’t explained it correctly but it isn’t one pie chart. It is two pie charts within one (the 2nd pie is a subset of one of the 1st pie segments)

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Pie within a Pie

    Thread title: Pie Within a Pie

    it isn’t one pie chart. It is two pie charts within one
    Seems to be what your title was expecting ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Pie within a Pie

    Thanks AliGW for the confirmation. I wanted to clarify as the example wasn’t what I required so was worried I wasn’t clear.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Pie within a Pie

    I still don't think you are clear. You need to show a mock-up of what you want.

  8. #8
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Pie within a Pie

    Hi

    I have provided an exmaple as to what I am trying to achieve - hope this helps
    Attached Files Attached Files

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Pie within a Pie

    There is no difference between what you have mocked up and what was offered in post #2 (other than the relative position and angle of the pie charts).

  10. #10
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Pie within a Pie

    Ahh!! Apologies! I was out when replying and this is how it appeared on my phone! I can mark this as solved! Thank you!
    Attached Images Attached Images

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Pie within a Pie

    OK - please do.

+ 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