How Excel makes a composite pie chart

How Excel makes a composite pie chart

The figure below is Huayi's 15 sales figures, including sales ratios for different channels.

Mainly including franchise stores, supermarkets, shopping malls wholesale and network sales, including the network sales are divided into Jingdong, Amazon and Dangdang three parts.

With the mother pie chart can be a good display of the distribution of each channel sales.

Next, let's talk about making steps.

First, adjust the data structure and move the "network" item to the end of the data:

Then insert the pie chart:

Generate a pie chart with a default effect, click the legend, and press the DELETE key to clear the legend:

Then double-click the pie chart to format the data series as shown:

Click the pie chart to change the H in the formula to G

Finally add the chart label, properly beautify the pie chart style, OK.