Building a nested chart using a pivot table

AnthoHead

New Member
Joined
Jul 20, 2014
Messages
17
I am looking to build a nested pie chart using a donut chart and am unable to figure out how to do this with a pivot table. I'm hoping to use the same data source as the rest of the charts and not wanting to create a new table just for this nested view, but understand that may not be possible. Below is an example of the data I would be using, but it would be in a Pivot table as it is not originally given to me this way. I'd like the inner table to show the year and the outer table to show the quarters for each year.

The goal would be to make something that looks like this, but from the pivot table at the bottom of this question.

1724855788920.png


Year​
Quarter​
Sales​
2021​
4​
$500​
2022​
1​
$600​
2​
$700​
3​
$800​
2023​
1​
$900​
2​
$1,000​
3​
$1,100​
4​
$1,200​
2024​
1​
$1,300​
2​
$1,400​
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
If there is a way to do this using the raw data, that would also suffice. I'm really hoping to be able to use slicers.
 
Upvote 0

Forum statistics

Threads
1,224,463
Messages
6,178,817
Members
452,881
Latest member
motivationgyan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top