Detailed steps for creating a multi-layered donut chart in Excel

php Xiaobian Zimo will show you how to create a multi-layered donut chart in an Excel spreadsheet. The donut chart is not only beautiful and elegant, but also clearly displays the relationship between data. Through detailed steps, you can easily master the skills of making donut charts, making your data presentation more vivid and interesting.

1. Suppose there is the following data, namely the sales of products 1-5 from January to April.

2. After selecting the data, insert the donut chart through the following path: Top Ribbon - Insert - Chart - Pie Chart - Donut Chart.

3. After selecting the chart, in the [Design] tab, use quick layout to set the format of the donut chart. This time, the last one is used, such as picture.

4. You can set the inner diameter of the ring by selecting the ring. The smaller the inner diameter, the larger the ring. If the inner diameter of the ring is 0, the inner diameter of the ring is 0. The layer is a pie chart with no hollows.

5. Right-click on the chart, add a numeric label, and then cancel showing the value and show the percentage instead.

6. You can also select the legend, right-click to set the format, and cancel the √ in front of [Show the legend, but do not overlap with the chart], so that the circle display range is more widely.

#7. For the separation of rings, only the outermost layer of rings can be separated. When other layers of rings are selected, the separation settings will become gray and cannot be set. In addition, whether to put it into the inner ring or the outer ring depends on the placement order of the sequence.

8. When making a ring through the above method, you can have the following results for reference.

The above is the detailed content of Detailed steps for creating a multi-layered donut chart in Excel. For more information, please follow other related articles on the PHP Chinese website!