How to Create a Pie Chart in Excel

By Aaron Parson

In Excel 2013, creating a pie chart takes only a single click -- choose a chart type and Excel builds the pie using your data. Adjusting the pie to your liking, however, requires a few more steps. Whether you want to change the chart's colors, add different labels or explode a pie segment to call it out, Excel provides the tools, once you know where to find them.

Step 1

**Enter a single row or column of data, optionally preceded by a single row or column containing labels for each value.** Your data can contain either raw values or percentages. To use percentages, make sure the sum of the values adds to 100 percent, and include the "%" sign after each number.

Step 2

Select your data and labels, and **click the pie chart icon on the Insert tab**. Pick one of the pie chart styles. For a standard pie chart, choose the first option in the 2-D Pie or 3-D Pie section. A 3-D pie chart might look nicer, but the effect also makes the data harder to interpret by artificially inflating the front wedge.

Step 3

Fill in the chart's name and use the *Chart Styles* section on the Design tab to give the chart a new look. Pick a style that includes data labels on the segments if you want to show percentage values.Press "Change Colors" to pick a new color scheme. For a pie chart, especially one with many sections, pick a color scheme with distinct colors to help differentiate the wedges.

Step 4

**Drag a piece of the pie chart away from the center of the circle to explode the pie.** To move a piece precisely, double-click it and change the *Point Explosion* value. An exploded pie chart helps emphasize specific wedges, but can also make the data less visually intuitive.

Step 5

Double-click any one of the segment data labels to change the contents of all data labels. To switch from percentages to raw values (assuming you provided raw values in your data), uncheck "Percentage" and pick "Value."

Step 6

**Choose the "Pie of Pie" chart type if you want to expand a group of pie segments into a secondary pie chart.** After picking this chart type, double-click the secondary pie to pick how many segments it should contain and how to select them. By default, Excel pulls out the three smallest segments.

Tips & Warnings

  • To add data labels manually, rather than picking a preset style, press "Add Chart Element" on the Design tab and choose "Data Labels."
  • Recolor a single piece of the pie by double-clicking it and selecting the paint bucket icon.