1
Vote

How do I create a pie chart in excel?

By Verity Painter on the 8th of January, 2013

1 Answer

  • 0
    Vote

    Pie charts are an excellent manner in which to display data points as a percentage of a whole. Meaning, a pie chart is a graphical representation of a data set, with pieces cut in proportion to the value of the category represented.

     

    For Example:

    Pie Chart Example

     

     

     

     

     

     

     

    People

    Number

    Pirates

    28%

    Ninjas

    31%

    Clowns

    41%

    Total

    100%

     

     

     

     

     

     

     

     

      

    1.                  Select the data that you want to display in the Pie of Pie or Bar of Pie chart.

    2.                  On the Insert menu, click Chart.

    3.                  In the Chart type box, click Pie.

    4. Click Next, and continue with Steps 2 through 4 of the Chart Wizard. (You can use the options presented to change the title, modify the formatting (colours, font, size) and the legend as you desire (you can add the values to be displayed, ex: Oranges = 2)

     

     

    Refine By Melissa-Anne Labranche on the 16th of January, 2013

Suggested reading…

Draw and interpret pie charts

Pie charts are a way of displaying data. They get their name because they look a bit like pies from above, with different sized slices of pie being cut depending on the data you have.

I your exam, you'll need to know both how to read pie charts, and also how to construct your own.

Example: 

First things first, we need to know how to read the data represented in a pie chart.

The chart below represents the results of a survey on a class of 24 students to find out their favourite colours.

Looking at the graph we can tell straight away, that half the class picked blue as their favourite colour. Yellow came in second with a quarter of the class choosing it, then red and green joint last with an eigth each. 

So by using the fractions of the circle, we can see that 12 students favour blue, 6 favour yellow,  3 favour green and 3 favour red.

To fully understand what a pie chart is you will need to know how to construct one

Constructing a Pie chart:

In order to construct a pie chart, we first need to find out the fraction of the total that each slice represents.

  1. First work out the total frequency. This can be done by adding all the frequencies together.
  2. Find the fraction of the total frequency for each colour. = Frequency/Total Frequency
  3. Then find the angle. = (Frequency/Total frequency) x 360

This will give you the angles shown in the table below, and then you just have to draw the graph using those angles.

Colour Frequency Angle
Blue 5 (5÷40)x360 = 45
Red 10 (10÷40) x 360 = 90
Green 10 (10÷40) x 360 = 90
Purple 15 (15÷40) x 360 = 135
Total 40 360

To draw a pie chart, follow the steps listed below: 

  1. Draw a circle using a compass
  2. From the centre draw a line vertically up. This will be the 0° line.
  3. Using a protractor and the 0° line use the angles you worked out to plot the pie char                                      

 

Taking IT global

Related Questions