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
Bookmarks