+ 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 - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    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

    RIP - d. 06/10/2022

    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
    O365
    Posts
    20,419

    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)

Similar Threads

  1. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  2. Step Chart with two data series/ Panel Chart
    By Alex E. in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-23-2014, 11:31 PM
  3. [SOLVED] Align Line Chart's data series Data labels on top of Bar chart data series
    By rgunlimited in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 10:38 AM
  4. Chart front-to-back series display if series are different chart types
    By Exconomist in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2012, 06:49 AM
  5. [SOLVED] Exclude one data series from scatter chart legend (but not from the chart)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 05:24 PM
  6. chart series data corrupted when chart has no data
    By timp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2006, 06:30 PM
  7. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01:05 PM

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