How to Make a Pie Chart in Microsoft Excel

When you need to show how individual parts make up a whole—such as displaying the percentage of total sales generated by different product categories, or breaking down a monthly household budget—a standard column chart can be difficult to read. The most effective way to visualize proportional data is by creating a Pie Chart.

Microsoft Excel makes creating a pie chart incredibly simple. If you have your data correctly formatted, you can generate a professional, presentation-ready chart in exactly three clicks.

This guide explains how to format your data and create a beautiful pie chart in Microsoft Excel.

Step 1: Format Your Data Correctly

A pie chart can only display one single series of data. Unlike a bar chart that can compare “Sales in 2023” next to “Sales in 2024,” a pie chart can only show the breakdown of one specific column of numbers. If you select too much data, the chart will fail.

You need exactly two columns of data:

1. Column A (Categories): The labels for your pie slices (e.g., Rent, Groceries, Utilities, Entertainment).
2. Column B (Values): The numbers corresponding to those categories (e.g., $1500, $400, $200, $150).

Do not include a “Total” row in your selection. If you include the Total row (e.g., $2250), Excel will treat it as another slice of the pie. The “Total” slice will take up exactly 50% of the entire chart, completely ruining the visualization.

Step 2: Insert the Pie Chart

Once your data is clean, inserting the chart takes only a few seconds.

1. Click and drag your mouse to highlight your data, including the column headers (e.g., highlighting from A1 down to B5). Remember to exclude the Total row.
2. Click the Insert tab on the main Excel ribbon at the top of the screen.
3. Look in the “Charts” group for the icon that looks like a round pie. Click it.
4. A small drop-down menu will appear. Select the very first option under “2-D Pie.”

Excel will instantly generate a basic pie chart and drop it directly onto your spreadsheet.

Step 3: Add Data Labels (Percentages)

By default, Excel usually creates a chart with a legend at the bottom indicating which color corresponds to which category, but it does not actually put the numbers on the pie slices. A pie chart without numbers forces the audience to guess the percentages based on the size of the slice, which is notoriously inaccurate.

You should always add data labels directly to the slices.

1. Click once on the pie chart to select it.
2. Look for a small green “+” (Plus) button that appears floating just outside the top right corner of the chart. Click it.
3. Check the box next to Data Labels. The numbers from your spreadsheet will instantly appear inside the slices.
4. To change those raw numbers into percentages, click the small black arrow pointing right, next to “Data Labels.”
5. Select More Options…
6. A formatting pane will slide out on the right side of your screen. Look under “Label Options.”
7. Uncheck the box for Value, and check the box for Percentage.

Step 4: Design and Formatting (Optional)

To make the chart look more professional for a PowerPoint presentation, you can quickly apply a pre-built design.

1. Click on the chart to select it.
2. Click the Chart Design tab on the ribbon (this tab only appears when a chart is selected).
3. In the “Chart Styles” gallery in the middle of the ribbon, click the down arrow to expand the menu and browse the options.
4. Select a style with a dark background or 3D beveling to make the data pop.

Finally, double-click the title at the top of the chart (which probably just says the name of your data column, like “Expenses”) and type a more descriptive title, such as “Q3 Household Budget Breakdown.”