Current location - Quotes Website - Signature design - How to create a circular proportional chart using EXCEL and add the name of each part
How to create a circular proportional chart using EXCEL and add the name of each part

The steps for taking office excel 2016 as an example are as follows:

The tools we need are: computer, office excel 2016

1. First open the excel table and create it Circle chart required.

2. Click the upper right corner of the chart and a cross button will appear. Click it to check the data label in the chart element.

3. Place the mouse on the data label and a small triangular arrow will appear next to it. Click it to select "More Options".

4. A dialog box for setting the data label format will pop up on the right. Click the last button "Label Options" and check the series name or category name in the options as needed.

5. After selecting the name, double-click the text in the chart to enter text editing and enter the required text.