+ Reply to Thread
Results 1 to 3 of 3

How to create a pie chart with sub-totals

  1. #1
    Registered User
    Join Date
    08-24-2018
    Location
    Phoenix, Arizona
    MS-Off Ver
    365
    Posts
    5

    How to create a pie chart with sub-totals

    Hi All-
    I've searched the forum (and the internet at large) for a solution to this one with no luck. Hopefully, someone here can help me create a pie chart that represents subtotals within each slice.

    Essentially, say I'm trying to represent our total sales last year where:
    20% came from apples
    10% came from bananas
    40% came from pears
    30% came from oranges
    This is the easy part - I can build this pie chart simply.

    Next, assume that we get all of our fruit from one of 3 vendors.
    For all the apples we sold, the breakdown was 10% were from Vendor 1, 40% Vendor 2, and 50% Vendor 3
    For our bananas sales, 40% came from Vendor 1, 35% from Vendor 2, and 25% from Vendor 3
    ...and so on and so forth.

    Is there a way to build the pie chart using our overall sales data so that the 20% Apples slice is subidvided into 3 proportional slices representing each of our vendors?

    I'm using Windows 10, Excel 365

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

    Re: How to create a pie chart with sub-totals

    There is a new chart type called subburst that will do that.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-24-2018
    Location
    Phoenix, Arizona
    MS-Off Ver
    365
    Posts
    5

    Re: How to create a pie chart with sub-totals

    Perfect! Thanks Andy.

+ 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. Help - How do I create a formula that allows me to add up weekly totals?
    By JamesOHands in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2014, 06:42 PM
  2. Replies: 1
    Last Post: 04-14-2010, 07:38 PM
  3. Create Sub Totals and Sum Total
    By georgeanaprop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 01:52 AM
  4. Pie Chart totals...
    By Jay3253 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2006, 10:00 AM
  5. Chart totals
    By Angela in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2006, 03:10 PM
  6. Programmatically create totals and names??
    By Jack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2006, 12:50 PM

Tags for this Thread

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