Current location - Recipe Complete Network - Dinner recipes - How to display quantity and proportion in excel table at the same time
How to display quantity and proportion in excel table at the same time
Tools: excel20 10, pie chart.

1, open excel, and fill in the required quantity and proportion data in the form first.

2. Then select all the data, click on the menu bar in the above line, design-pie chart, and then choose a style casually, as shown in the figure.

3. Then right-click the pie chart and select the option of formatting data labels.

4. Then enter the settings page, and click on the category name, value, percentage, and √ showing the guide line, as shown in the figure.

5. Finally, back to the pie chart, you can see that all the data you want are out, and the quantity and proportion are also there.