Current location - Loan Platform Complete Network - Big data management - How to present data in a double layer pie chart?
How to present data in a double layer pie chart?

1. Insert the pie chart by selecting columns A and D, i.e. the name and amount of the broad category.

2. Right click on the pie chart and select ? Select Data? , and then Add, then the series name to type it yourself, series value to choose the single sales in column C.

3. Set up a two-tier pie chart. The point comes ah. Point on the pie, right-click and select ? Set data series format? , the right side will come out some options, select ? Sub-axis? and then put? Pie chart separation degree? Set up, here I am set 50%, the back of the demand can be based on their own, you will get a piece of the pie charts separated ~ ~ ~

4. One by one, remember to remember is one by one Oh, move the pie chart to the middle of it. Hey, hey, hey, hey, hey, hey, hey, hey, hey, hey, hey, hey, hey, hey.

5. Add the name of the corresponding snacks to the single profit, just when we added in the name is still a number, so people look confused.

6. Right click on the pie chart and select ? Add Data Label? Then select the label that pops up, right click and select ? Set Data Label Format? , and type the category name in the list? After that, just neaten up the formatting to your needs to look good.

On how to use a double-layer pie chart to show data, how to start the content, the green vine editor will share with you here. If you have a strong interest in big data engineering, I hope this article can help you. If you still want to know more about data analysts, big data engineers tips and materials and other content, you can click on other articles on this site to learn.