Open the report and set the percentage data template.
Overlapping pie charts and composite pie charts only support the separation of percentage series, so we calculate the proportion of payable amount in each region, hide column B, enter the proportion in C 1, and enter the formula = B2/ sum (B2[! 0])，B2[！ 0] refers to all cells expanded by B2, and the cell style can be set according to the situation.
Take making a pie chart as an example, select the chart and check the chart property sheet-style >；; In the second drawing area of the series, the data in the second drawing area is changed to 10, and the default value is 5, which means that the second drawing area contains all values less than this percentage, as shown below:
According to the situation, you can set the series label style, and check the chart property sheet-style >；; Label In the label, select a value, format it, and keep the percentage to two decimal places.
Modify chart data
Modify chart property sheet-data >; If the legend item value is C2 cell, you can set a composite pie chart.
Preview and save
Save the template and click Page Preview to see the effect.