Pie chart

You can edit charts in a variety of ways. For this sample pie chart, we will:

  • Add a title.
  • Remove the small category of "missing" data.
  • Display percentages for the two remaining categories in the chart.

The first thing we'll do is add a title:

step Double-click the pie chart to open it in the Chart Editor.

step From the Chart Editor menus choose:

Chart
  Title

step For Title 1, enter Home Internet Service and then click OK.

A descriptive title is now displayed above the pie chart.

Now we'll remove the small category of missing data. For information on missing data, see Handling Missing Data.

step From the Chart Editor menus choose:

Series
 Displayed

step Move Missing from the Display list to the the Omit list and click OK.

The category of missing data has beeen removed from the pie chart, leaving only two categories.

The pie chart clearly shows that most respondents do not have internet service at home, and it looks like almost three-quarters of the respondents are in the No category -- but it might be useful to see the exact percentages.

step Double-click one of the two category labels (No or Yes).

step Select (check) Percents.

While we're here, let's move the category labels from the outside to the inside of the pie.

step Click Format.

step Select Inside from the drop-down list.

step Deselect (uncheck) Inside labels to suppress the display frame.

step Click Continue and then Click OK.

Now percentages are displayed along with the category labels -- and both are displayed inside the pie slices.

The percentages are based on the two categories displayed (73.4 + 26.6 = 100). If you put the category containing missing values back into the pie, the percentages would change.