+ 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
    2003, 2007, 2010 & 2013
    Posts
    18,589

    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)

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