How to Make a Pie Chart for Math in Excel

Step-by-Step Guide

1. 1

   Step 1: Have some categorized data available.

   It would be helpful if it added up to 100%.
   
   This article will provide example data and you can substitute in your own.
   
   Above is a picture of the finished example. , Double click on Excel (either the green X on the dock or the app title in the folder) and select File New Workbook., In General, set R1C1 to unchecked or Off; in Ribbon, set Ribbon to checked or On; and in View, set Show Formula Bar by Default to checked or On.,,,, Then Hit OK.,,,, Center., The $ signs in "$P$20" make hat an "absolute reference" that does not change automatically as you copy and paste the formula to other cells. "Relative references" (those without dollar signs) do change automatically.
   
   Recommended: investigate the results of the next step in each cell to learn the difference between relative and absolute references. ,,,,, The pie chart will appear with the top right area showing 18% of the chart for Camels; the next right area will be 10% for Elephants and the area next clockwise down will be 10% for Hippos, and the next (largest area on the boom) will be 35% for Monkeys.
   
   You have successfully created the pie chart you wanted., Hover the mouse over the corners or edges until the mouse cursor turns into a double-headed arrow and then pull to expand or push to shrink the chart to that it looks good beside your data, and will print out nicely if you are opting to print your work.,, There is a way to substitute the categories for the category numbers given beside the series colors in the chart legend:
   Click inside the chart right on one of the chart sections itself and notice up in the formula bar that the following formula appears =SERIES(,,Sheet1!$N$12:$N$19,1).
   
   If you modify it to read =SERIES(,{"Camels"
   
   "Elephants"
   
   "Hippopotami"
   
   "Monkeys"
   
   "Rhinoceri"
   
   "Spiders"
   
   "Tigers"
   
   "Lions"},Sheet1!$N$12:$N$19,1), then the category names will be substituted for the automatic category list-numbers.
   
   This is an array.
   
   Yes it's a pain but each category must be in quotes w/ no spaces, separated by commas and the whole in braces.
   
   You may want to resize the legend a bit to correct for formatting problems.
2. 2

   Step 2: Open a new workbook in Excel from the desktop

3. 3

   Step 3: from the dock

4. 4

   Step 4: or from your applications folder inside the Microsoft folder.

5. 5

   Step 5: Go to Preferences.

6. 6

   Step 6: Enter to cell M11

7. 7

   Step 7: Zoo Animals.

8. 8

   Step 8: Enter to cell P11

9. 9

   Step 9: Count.

10. 10

    Step 10: Enter to cell L12

11. 11

    Step 11: Select cell range L12:L19 and do Edit-Fill-Series-(Columns-Linear-Step Value=1).

12. 12

    Step 12: Enter the following animal names to cells M12 to M20: Camels

13. 13

    Step 13: Elephants

14. 14

    Step 14: Hippopotami

15. 15

    Step 15: Monkeys

16. 16

    Step 16: Rhinoceri

17. 17

    Step 17: Spiders

18. 18

    Step 18: Tigers

19. 19

    Step 19: Lions and Total.

20. 20

    Step 20: Enter beneath count in cells P12 to P19 the counts per animal type: 54

21. 21

    Step 21: Enter to cell P20 the formula =SUM(P12:P19).

22. 22

    Step 22: Select columns L to P at top and Format Cells > Alignment > (Horiz.)

23. 23

    Step 23: Enter to cell N12 the formula =P12/$P$20.

24. 24

    Step 24: Copy cell N12 and paste it to cell range N13 to N20.

25. 25

    Step 25: Select cell range N12:N19 entirely.

26. 26

    Step 26: On the Ribbon

27. 27

    Step 27: select the Charts button.

28. 28

    Step 28: Select the Pie icon.

29. 29

    Step 29: Select the plain old 2-D simple Pie chart at upper left for now.

30. 30

    Step 30: Select along the edge of the chart and drag it away from the data.

31. 31

    Step 31: Save the file.

32. 32

    Step 32: Adjust the appearance if needed.

Detailed Guide

About the Author