- 1 How to Make a Quick Pie Chart in Excel
- 2 How to Label a Pie Chart in Excel
- 3 How to Customize a Pie Chart in Excel
- 4 How to Explode a Pie Chart in Excel
- 5 How to Create a Pie of Pie Chart
- 6 How to Create a Bar of Pie Chart
- 7 Extra: How to Make a Bar Graph in Excel
- 8 Extra: How to Find Duplicates in Excel Data and Remove Them
Pie charts are an incredibly useful tool when you want to highlight the differences between certain data points. However, though great, they aren't exactly precise – it's hard to discern an accurate number from the angle of a particular section. In this article we're going to show you how to create a pie chart in Excel with labels so that you can have the best of both worlds.
How to make a pie chart in Excel: There are different ways
We'll first look at creating a basic Excel pie chart, then move on to adding labels, customizing its visuals, exploding the pie chart, and finally creating a pie chart with a bar chart to the side.
Before you put the time in to make a pie chart in Excel, do bear in mind that you can only display a single data series in one and are unable to use zero or negative values. If your data set doesn't fit those requirements, you may be better served by our bar chart tutorial, which is linked at the bottom of the page.
How to Make a Quick Pie Chart in Excel
Creating a basic pie chart in Excel is really easy. In fact, we only need a single step and four clicks to show you how:
- Select your data and press the pie icon in the “Insert” tab of the ribbon
You can then choose which type of pie chart you want. In our case, that's the basic “2-D Pie” option. However, you can also create a 3d pie chart in Excel by pressing the option under “3-D Pie”.
How to Label a Pie Chart in Excel
So, you have a basic pie chart now, but your viewers will likely be hard-pressed to tell whether some segments are bigger than others and exactly how much by. We can solve this by adding data labels, which will clearly display the number on top of each segment:
- Right-click your graph and choose “Add Data Labels”
- Your data will automatically appear on the pie segments
- Customize them by right clicking the graph and pressing “Format Data Labels…”
- Tick what you want each label to contain and choose where to position them
For example, you can add an Excel pie chart percentage by ticking the “Percentage” option.
- Preview the changes on your pie chart and close the formatting window when you're done
How to Customize a Pie Chart in Excel
The default design of pie charts in Excel is very plain and often uses colors that aren't visually appealing. You can fix this by modifying your chart design, color palette, and gradient.
- Click on your pie chart in Excel and choose a style from the “Chart Design” tab
You'll find various styles above the “Chart Styles” heading which will give your chart a fresh look.
- Press “Change Colors” and pick from one of the color palette presets
- OR: Open the “Page Layout” tab and press “Themes”, then pick an option
Bear in mind that this will change the settings across your entire document, rather than just this particular graph.
- Click the four squares next to the Themes button to change your chart colors
- Press the text icon to change your font
- Click the shape icon and choose a shading type for your elements
How to Explode a Pie Chart in Excel
It sounds dramatic, but when you explode a pie chart in Excel all you're doing is adding spacing between the pieces. This is quite easy to achieve, and you can do it manually or automatically
- Click on your chart to select it
- Click again and drag to the side
You'll see a dotted blue border around your pie that will indicate how far out your pie will explode.
- Release your mouse button to apply the changes
- OR: Click a single slice to select it
- Drag it out to move it individually
You can repeat the process for each slice in your pie or leave it as-is if you want to highlight a particular result.
How to Create a Pie of Pie Chart
It's may feel a bit silly, but there are several instances where you may want to create a separate pie chart out of only part of the data from your original pie. This is inventively named the “Pie of Pie” chart. Here's how to make one:
- Select your data, press the pie icon in the “Insert” tab of the ribbon, and click the pie of pie icon
A pie of pie chart in Excel is indicated by a picture of a big and small pie with lines between them.
- Change the data used for the pie of pie by right-clicking and choosing “Format Data Series…”
- In the series options, choose what you want to split the data series by
- Close the data series window once your preview looks correct
How to Create a Bar of Pie Chart
Alternatively, you can create a Bar of Pie chart, which as you may expect displays a small bar chart next to your data for the smallest. This is quite useful, as it lets viewers more easily see the differences between them:
- Select your data, click the pie icon, and choose the Bar of Pie chart option
The option is in 2-D pie settings, next to the pie in pie icon.
- The smallest sections of your pie will be automatically split into a bar chart
Extra: How to Make a Bar Graph in Excel
If you realized that a pie chart doesn't really work with your data set, chances are you can't go wrong with a trusty bar graph. We even have a dedicated bar graph in Excel guide to help you make one.
Extra: How to Find Duplicates in Excel Data and Remove Them
If you noticed that you've entered the same data multiple times after creating your pie chart (a common mistake) you can try some of the formulas in our how to find duplicates in Excel guide. They should get rid of them and save you a lot of manual deletion.