If you have a list of numbers and want to understand how each part contributes to the total, a pie chart can make the data much easier to read. In Excel, creating one only takes a few steps.
You can use a pie chart for things such as monthly expenses, survey responses, sales categories, or any other data where you want to show parts of a whole.
In this guide, you’ll learn how to create a pie chart in Excel, display percentages, customize the chart, and choose between different pie chart styles.
Also read:Â How to Add a Text Box in Google Docs
What Is a Pie Chart in Excel?
A pie chart displays data as slices of a circle. Each slice represents one category, while its size shows how much that category contributes to the total.
For example, suppose your monthly expenses look like this:
| Expense | Amount |
|---|---|
| Rent | 15,000 |
| Groceries | 6,000 |
| Transport | 3,000 |
| Bills | 4,000 |
A pie chart can turn these figures into a visual representation, making it easier to see which expenses account for the largest share.
Pie charts are generally most useful when you have a single set of values divided into a reasonable number of categories.
How to Make a Pie Chart in Excel
Follow these steps to create a basic pie chart.
Step 1: Enter Your Data
First, arrange your information in two columns.
Put the category names in the first column and the corresponding numbers in the second column.
For example:
| Category | Amount |
|---|---|
| Rent | 15000 |
| Groceries | 6000 |
| Transport | 3000 |
| Bills | 4000 |
Including column headings can also help Excel identify what your data represents.
Step 2: Select the Data
Highlight the categories and their corresponding numbers.
Make sure you select only the data you want to include in the chart. If your table has headings, include those as well.
Step 3: Insert the Pie Chart
With the data selected:
- Open the Insert tab in Excel.
- Find the Charts section.
- Select Insert Pie or Doughnut Chart.
- Choose 2-D Pie.
Excel will create the chart using the selected data.
The chart may use the heading of your numerical column as its title. You can change the title later if necessary.
How to Show Percentages on an Excel Pie Chart
Percentages can make a pie chart easier to understand because readers can immediately see each category’s share of the total.
To add them:
- Select the pie chart.
- Open the Chart Design tab.
- Choose Quick Layout.
- Select a layout that displays data labels, such as Layout 1.
Excel will add labels to the slices.
Add More Control Over Data Labels
You can also choose exactly what information appears beside each slice.
Select the chart and use the Chart Elements (+) button. Turn on Data Labels, then open the additional formatting options.
Depending on what you need, you can display:
- Category names
- Values
- Percentages
- A combination of these
You can also adjust the position of the labels so they appear inside or outside the slices.
How to Customize a Pie Chart in Excel
Once the chart has been created, you can change its appearance without changing the underlying data.
Change the Chart Title
Click the existing title and type your preferred title.
For example, instead of a generic title, you could use Monthly Household Expenses.
Change the Colors
Select the chart and go to Chart Design > Change Colors to choose a different color combination.
You can also format an individual slice when you want to highlight a particular category.
Highlight a Slice
If one category deserves extra attention, you can separate its slice slightly from the rest of the pie.
Select the relevant slice and drag it outward from the center of the chart.
Use this effect sparingly because separating several slices can make the chart harder to read.
Resize or Move the Chart
To reposition the chart, drag its border to another location on the worksheet.
To change its size, drag one of the corner handles.
Which Pie Chart Type Should You Use?
Excel provides several variations of pie charts. The best choice depends on how you want to present the information.
2-D Pie Chart
This is the standard pie chart and is usually the simplest option for comparing parts of a whole.
For most basic data, this is a good starting point.
3-D Pie Chart
A 3-D pie chart adds a three-dimensional appearance. However, the visual perspective can sometimes make it harder to compare the sizes of slices accurately.
If clarity is more important than appearance, a standard 2-D pie chart is often preferable.
Doughnut Chart
A doughnut chart is similar to a pie chart but has an empty space in the middle.
The center can sometimes be useful for displaying additional information, depending on the design.
Pie of Pie and Bar of Pie
When some categories are much smaller than others, a regular pie chart may make those smaller slices difficult to distinguish.
Excel’s Pie of Pie and Bar of Pie options can separate smaller portions into a secondary chart, making them easier to examine.
When Should You Use a Pie Chart?
A pie chart is most useful when your data represents portions of a single total.
Good examples include:
- Household spending by category
- Survey responses
- Sales divided by product category
- A budget divided into different expenses
- Market or customer segments
A pie chart may not be the best choice when you have many categories or need to compare small differences between similar values. In those situations, a bar or column chart may communicate the information more clearly.
Tips for Making a Clear Pie Chart
Keep these points in mind when creating one:
- Use one main data series.
- Keep the number of categories manageable.
- Avoid unnecessary visual effects.
- Use descriptive labels.
- Show percentages when they help explain the data.
- Make sure the values represent meaningful parts of one whole.
- Avoid using a pie chart when individual values need very precise comparison.
Common Problems With Excel Pie Charts
Why Is My Pie Chart Showing Only One Color?
This can happen if Excel has interpreted your data incorrectly.
Check whether your categories and numbers are arranged in separate columns. You can also select the chart and use Chart Design > Switch Row/Column to change how Excel interprets the data.
If that does not solve the problem, select the chart’s data again and make sure you have chosen one category column and one numerical column.
Can Excel Calculate the Percentages Automatically?
Yes. Excel can calculate each slice’s percentage from the underlying values.
You do not need to manually calculate the percentage just to display it on the chart. Add data labels and select the percentage option.
If you also need those percentages stored in worksheet cells, you can calculate them separately using Excel formulas.
Can I Put an Excel Pie Chart Into Word or PowerPoint?
Yes. You can copy the chart from Excel and paste it into applications such as Word or PowerPoint.
The exact paste options available may vary depending on how you want the chart to behave after it is inserted.
Frequently Asked Questions
How do I make a pie chart in Excel?
Enter your categories and corresponding numbers, select the data, go to Insert, choose Insert Pie or Doughnut Chart, and select 2-D Pie.
How do I add percentages to an Excel pie chart?
Select the chart, open the chart elements options, enable Data Labels, and configure the labels to display percentages.
Can I change the colors of individual pie slices?
Yes. You can format individual slices if you want to highlight particular categories.
What is the difference between a pie chart and a doughnut chart?
Both display parts of a whole. A doughnut chart has an empty center, while a standard pie chart is filled in the middle.
Is a 3-D pie chart better than a 2-D pie chart?
Not necessarily. A 3-D chart can look more decorative, but the perspective may make comparing slice sizes more difficult. A 2-D pie chart is often easier to read.
Also read: How to Block a Website on Chrome: 4 Easy Methods
Conclusion
Creating a pie chart in Excel is straightforward once your data is organized into categories and corresponding values. Select the data, use the Insert tab to choose a pie chart, and then add percentages or other labels if they make the information clearer.
For simple parts-of-a-whole comparisons, a 2-D pie chart is usually the easiest place to start. If your data contains many categories or requires precise comparisons, consider whether another chart type would communicate the information better.
Abhi Rajput, founder of Earnabhi.com, is a tech lover with 6+ years of experience in SEO, digital tools, and smartphone troubleshooting. He writes simple, clear, and useful guides to help people solve real tech problems.