Category: How to Create a Pie Chart in Excel (Free Template)

How to Create a Pie Chart in Excel (Free Template)

In this step-by-step tutorial, you will learn how to create a pie chart in all versions of Excel: 2003, 2007, 2010, 2013, 2016, and 2019.

A pie chart (also known as a circle chart) is a circular graph where each slice illustrates the relative size of each element in a data set.

Stick around to learn all about how to quickly build and customize pie charts.

Excel Pie Chart Template – Free Download

The Fastest Way to Create a Pie Chart in Excel

Without beating around the bush, let me show you the easiest and fastest way to build circle charts. Here’s some dummy data we’re going to use:

Excel pie chart sample data

Read More: How to Create an In-cell Pie Chart in Excel

To build a pie chart with that data, all you need to do is follow a few simple steps:

  1. Highlight the entire data table (A1:B6).
  2. Go to the Insert tab.
  3. Click “Insert Pie or Doughnut Chart.
  4. Choose “Pie.

Insert pie chart

Ta-da! There you have your pie chart.

Excel pie chart free template

But here’s more to it than that. If you want to explode a single slice of your pie chart, just double-click on the slice you want to explode and drag it away from the chart center.

Explode a single slice of a pie chart

Read More: How to Create a Pie Chart from a Single Column in Excel

How to Add Labels to a Pie Chart

To make our circle chart a bit more informative, add some data labels illustrating the numeric value of each slice by right-clicking on your pie chart and choosing “Add Data Labels.

Add data labels to pie charts

Once there, Excel will automatically generate dynamic data labels based on your actual values.

Pie chart with data labels

The default data labels just don’t cut it, so let’s customize them a bit to make the chart more visually appealing.

To start with, right-click on any of the data labels and choose “Format Data Labels.

Format pie chart data labels

In the task pane that appears, do the following to spruce up your data labels:

  1. Navigate to the “Label Options” tab.
  2. Under “Label Options,” select “Category Name” to display the product categories next to the actual values.
  3. Under “Label Position,” click “Outside End” to push the labels outside the pie chart.

Choose "Category Name" and "Outside End"

Having changed the font and background color of the labels on top of those tweaks, here’s how our pie chart should look like now.

Excel pie chart with custom labels

The “Label Options” tab provides a whole host of customization options to create professionally-looking pie charts using basic Excel features and tools.

Read More: How to Create a Half Pie Chart in Excel

How to Change Pie Chart Colors

To quickly change the color of the slices in your pie chart, here’s what you need to do:

  1. Double-click on the slice you want to modify.
  2. Click “Format Data Point.

Recolor a single slice

  1. Go to the “Fill & Line” tab.
  2. Click “Fill Color” and choose black from the color palette.

Change the color of a pie chart

Now, over to you! You now have all the information you need to build stunningly beautiful circle graphs in Excel.

Read More: How to Create A 3-D Pie Chart in Excel