Author: Oscar Cronquist Article last updated on September 06, 2018

The pie chart is used to graph parts of a whole, the total of our numbers must be 100%. The pie chart is, unfortunately, one of the most use charts, you see them often in newspapers and magazines. You shouldn't use them at all, in my opinion, they are hard to read and not that useful.

How to build

  1. Select the cell range that contains the values you want to chart.
  2. Go to tab "Insert" on the ribbon.
  3. Click the "Pie or Doughnut Chart" button.
  4. Click the "Pie Chart" button.

Improve the pie chart

There are a few things we can do to make the pie chart a little easier to read.

Add data labels

  1. Right click on chart to open a menu.
  2. Click on "Add Data Labels".
  3. Select the data labels and change the font size.

Sort values

  1. Right-click on one of the chart data source values.
  2. Click "Sort" then click "Sort Largest to Smallest".

The chart pies are now sorted from largest to smallest and the data labels show how large they are.

 

 

Related articles