Easily create a proportion stacked chart in Excel
Kutools for Excel
Boosts Excel With 300+
The proportion stacked chart is an alternative to pie chart, which can visually show proportions of a whole. It is made of 100 squares representing the whole, and the squares can be shaded based on the relation of several parts to a whole. How to create a proportion stacked chart in Excel? Here the Proportion Stacked Chart utility of Kutools for Excel can do you a favor.
Create a proportion stacked chart in Excel
Supposing you have a table containing the products and their sales proportions, and you want to create a proportion stacked chart based on it, please do as follows to get it done.
1. Click Kutools > Charts > Category Comparison > Proportion Stacked Chart to enable the feature.
Tips: You also can select the data range in advance and then enable the feature.
2. In the Proportion Stacked Chart dialog box, please configure as follows.
Note: If you have selected the data range in step 1, ranges will be automatically outputted in the corresponding boxes after enabling the feature. Otherwise, select the ranges one by one manually.
Note: Click the Example button will open the chart sample workbook.
3. If you select Chart in Chart type section, after clicking the OK button in step 2, a Kutools for Excel dialog box will pop up, please click the Yes button.
And if you select Mini chart in the Chart type section, after clicking the OK button in step 2, a Select data dialog will pop up, please select a cell to output the mini chart, and then click the OK button.
Then the proportion stacked chart is created in current worksheet.
A proportion stacked chart
A mini proportion stacked chart
Change the size and shape of the squares in a proportion stacked chart
After creating the chart, if you want to display all the 100 shapes as ovals instead of squares, and enlarge the ovals, please do as follows.
Change the color of the squares in a mini proportion stacked chart.
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.