Excel how to make a composite pie chart Excel to do a composite pie chart tutorial

In the Excel table statistics we often do some chart class work. If you use a lot of line charts, bar charts, and pie charts, it's not easy to design beautiful statistical charts. Let's take a look at how to make a beautifully-composed composite pie chart.

Steps

We got a table for a different kind of value or percentage, and Xiaobian designed a table. This is quite typical, and the statistics of various websites are mainly Websites are big, small websites are classified as others, but small websites should also be displayed. How to present them beautifully?

First we have to select the data, the other 15% is the reference does not need to choose, and then click to insert the composite pie chart in the pie chart; in fact, the composite chart has a bar, a polyline, etc., we choose the pie chart example.

After selecting the pie chart, we saw that the pie chart is not standardized, and it looks unsightly. It is not very clear that everyone sees this part. Just come out with a sketch, then let's see it!

Design charts often use tool formats and the like. We don't need to select tool data in Excel, just select the pie chart and right click on the pie to select “set the data series format";

The Set Format dialog box will pop up. The default option on the left is the series option. We don't need to change the default. On the right side we can see some setup options. The split is based on the default position. The second draw. What is the last one? The other ones are classified as 7 others, so choose 7. This value can be set arbitrarily.

The following separation degree, classification spacing, and second drawing size can be tried. Separation means that the pie chart is scattered to the square, the classification pitch is the pitch of the two pie charts, and the second drawing size is the size expansion of the second pie chart.

After the setup is complete, there is no need to save and the graph changes automatically. See the picture for details!

After setting the icon, the icon is not very beautiful. We select the chart and click the icon, then select the above design; select the first one of the layout icon;

There has been a change. As you can see, the first drawing has other words with names and percentages, which are quite clear. Then change the title of the icon to the name, such as: visit the website ratio composite map.