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.
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:
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:
- Highlight the entire data table (A1:B6).
- Go to the Insert tab.
- Click “Insert Pie or Doughnut Chart.”
- Choose “Pie.”
Ta-da! There you have your pie chart.
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.
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.”
Once there, Excel will automatically generate dynamic data labels based on your actual values.
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.”
In the task pane that appears, do the following to spruce up your data labels:
- Navigate to the “Label Options” tab.
- Under “Label Options,” select “Category Name” to display the product categories next to the actual values.
- Under “Label Position,” click “Outside End” to push the labels outside the pie chart.
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.
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:
- Double-click on the slice you want to modify.
- Click “Format Data Point.”
- Go to the “Fill & Line” tab.
- Click “Fill Color” and choose black from the color palette.
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