Pie Charts

[patrickstar]

I would like to be able to select any segment on a pie chart in Excel 2016 and, by this action, an additional pie chart can be displayed for a further breakdown of that particular slice.

For example a pie chart showing differing vehicle types and when the 'car' slice is chosen a new pie chart appears to show the breakdown of the differing car makes observed.

Thank you

[Calibax]

This any help?
https://www.officetooltips.com/excel_2016/tips/creating_pie_of_pie_and_bar_of_pie_charts.html

[patrickstar]

Hi Calibax. The website directions aren't the clearest but maybe that's just me. I really just want a simple step by step process on how if clicking a segment a pop up pie chart or graph appears until the next click. Maybe this isn't possible but will keep looking. Thank you