A stacked bar chart is a good substitute for a pie chart, and works especially well when you want to show how one section is broken down into sub-sections. This type of visual is a good substitute for multiple pie charts such as the Pie of Pie and Bar of Pie chart choices. The standard stacked bar chart is used, with some settings that highlight the breakout portion and the sub- sections.
While figuring out the calculations is not too difficult, the calculator I have created will make it easier and provide a results table that is easy to copy to create an Excel or PowerPoint stacked bar chart. It is part of my Calculators For Visuals Excel file that you can download.
Right-click on this link and select to Save the file to your computer. Then open the file you have downloaded in Excel.