How to Create a Pie Chart in Excel: Step-by-Step Guide

To create a pie chart in Excel, first select your data including labels and values. Then go to the Insert tab, click on Pie Chart in the Charts group, and choose the style you want to display your data visually.

Syntax

Creating a pie chart in Excel involves selecting your data and using the Insert menu to add the chart. The basic steps are:

• Select Data: Highlight the cells with your categories and values.
• Insert Pie Chart: Go to the Insert tab, find the Charts group, and click Pie Chart.
• Choose Style: Pick the pie chart style you want (2-D, 3-D, Doughnut, etc.).

excel

No direct formula code; use Excel ribbon commands to create the chart.

Example

This example shows how to create a simple pie chart from sales data by product category.

text

1. Enter data in Excel:

   A1: Category
   A2: Apples
   A3: Bananas
   A4: Cherries

   B1: Sales
   B2: 30
   B3: 45
   B4: 25

2. Select cells A1:B4.
3. Click the <Insert> tab.
4. Click <Pie Chart> in the Charts group.
5. Choose <2-D Pie>.

Excel will create a pie chart showing sales distribution by category.

Output

A pie chart appears showing three slices labeled Apples (30), Bananas (45), and Cherries (25).

Common Pitfalls

Common mistakes when creating pie charts include:

• Not selecting both labels and values, which causes the chart to miss category names.
• Including empty or non-numeric cells in the data range, which can cause errors or blank slices.
• Using too many categories, making the pie chart cluttered and hard to read.
• Choosing inappropriate chart types for data that is not part of a whole.

text

Wrong way:

Select only values (B2:B4) without labels (A2:A4).

Right way:

Select both labels and values (A1:B4) to show category names on the chart.

Quick Reference

Step	Action
1	Select data range including labels and values
2	Go to Insert tab on the ribbon
3	Click Pie Chart in Charts group
4	Choose desired pie chart style
5	Adjust chart title and labels if needed

Key Takeaways

Always select both category labels and numeric values before inserting a pie chart.

Use the Insert tab and Pie Chart button to create charts quickly without formulas.

Avoid including empty or non-numeric cells in your data selection.

Limit the number of categories to keep the pie chart clear and readable.

Customize chart titles and labels after creating the pie chart for clarity.