Pie Chart in Excel

Visual interpretations of numbers can often help us understand the context that numerical data cannot easily convey, because large datasets can often provide us with very complex information to interpret. Visualization tools, including pie charts, allow you to visualize your data in ways that are visually appealing and are much easier to read than just the numbers alone.

If you are looking at sales performance, reviewing survey findings, looking at your total expenses or have business trends that you want to share with others, pie charts can provide your audience with the essential data you wish to convey as quickly as possible. You can create a pie chart in about five minutes in Excel and immediately show your audience how parts of the data contribute to the total amount.

In this guide, you will learn everything about pie charts in Excel, from the basics all the way to advanced tricks that most users never discover. Every step is written so you can follow along directly in Excel as you read. No guesswork. No skipping steps.

Let us get started.

Read Also: How to Find Standard Deviation in Excel?

What Is a Pie Chart in Excel?

A pie chart in Excel is a circular chart that divides your data into slices. Each slice represents one category, and the size of that slice shows how much that category contributes to the total. Think of it like a pizza. If Digital Marketing takes 40% of your budget, Digital Marketing gets 40% of the pizza.

Excel builds pie charts from just two things:

• A list of category names (like departments, products, or regions)
• A list of values for each category (like sales, headcount, or spend)

When Should You Use a Pie Chart?

Use a pie chart in Excel when:

• You want to show part-to-whole relationships
• You have 5 to 7 categories or fewer
• The differences between your slices are clearly visible
• You are presenting data to a general audience

When Should You Avoid a Pie Chart?

Avoid a pie chart when:

• You have more than 7 categories (the chart becomes cluttered)
• Multiple slices have very similar values (hard to distinguish visually)
• You are tracking trends over time (use a line chart instead)
• You need to compare exact values (use a bar chart instead)

Related Article: How to Subtract in Excel?

Types of Pie Charts in Excel

Excel gives you six types of pie charts. Each one serves a different purpose. Here is what each does and when to use it.

1. 2-D Pie Chart

This is the standard pie chart. It is flat, clean, and easy to read. Use this for most everyday presentations and reports.

2. 3-D Pie Chart

This adds a three-dimensional effect to your chart. It looks impressive in presentations, but the 3-D angle can visually distort slice sizes. Use it carefully.

3. Pie of Pie Chart

This chart splits small slices into a second, separate pie. It is perfect when you have several tiny categories that are hard to see in the main pie.

Also Read: How to Separate Names in Excel?

4. Bar of Pie Chart

Similar to Pie of Pie, but the secondary chart is a bar chart instead of another pie. Some people find this easier to read than a second pie.

5. Exploded Pie Chart (2-D)

This pulls all slices apart slightly from the center. It highlights the entire chart and works well when you want emphasis on the whole, not just one slice.

6. Exploded Pie Chart (3-D)

Same as the exploded version but with a 3-D look. Use it sparingly since the effect can become visually noisy.

How to Create a Basic Pie Chart in Excel

I will use this dataset in every single section of this guide. Enter it into your Excel worksheet now so you can follow along step by step.

Total Budget: $120,000

This is a 2025 Annual Marketing Budget broken down across five departments. The numbers are realistic, the categories are clear, and the spread is wide enough that every chart type we cover will look good and make sense.

Enter this data with "Department" in cell A1, "Budget (USD)" in cell B1, and the five rows of data below in rows 2 through 6. Enter the budget values as plain numbers (45000, not $45,000) so Excel reads them correctly.

You already entered the marketing budget data above. Now turn it into a working pie chart in four steps.

Step 1: Set Up Your Data

Confirm your worksheet looks exactly like this before moving on:

Tips for clean data setup:

• Enter budget values as plain numbers (45000, not $45,000 and not "45,000")
• Do not leave any blank rows between rows 2 and 6
• Make sure B2 through B6 are formatted as Number, not Text. Select those cells and check the format dropdown in the Home tab

Read Also: Excel Multiply Formulas

Step 2: Select Your Data

Click on cell A1. Hold your mouse and drag down to cell B6 to highlight all six rows, including the header row.

You will see a blue-highlighted box around the range A1:B6. That is your selection.

Pro tip: Click A1, then hold Shift and click B6 to select the same range without dragging.

Step 3: Insert the Pie Chart

1. Click the Insert tab at the top of Excel

2. Look for the Charts group in the ribbon

3. Click the Pie Chart icon (it looks like a circle with one slice cut out)

4. A dropdown menu will appear with chart subtype options

5. Click 2-D Pie (the first icon at the top left)

Excel will instantly create your pie chart on the same worksheet. You will see five colored slices, one for each marketing department. Digital Ads take the largest share at 37.5% of the pie (45,000 out of 120,000).

Step 4: Move the Chart to a Better Position

Click anywhere on the white border of the chart. Drag it to an empty area below your data, around row 9 or 10. This prevents the chart from overlapping your data table.

Your pie chart is now live. If you go back and change the Digital Ads budget in cell B2 from 45000 to 50000, the slice will instantly grow larger. That is how tightly connected Excel charts are to their source data.

Also Read: How to Create Dashboard in Excel? A step-by-step Guide

Customizing Your Excel Pie Chart

The default pie chart works, but a customized pie chart communicates. Here is how to make your marketing budget chart professional and polished.

How to Add a Chart Title

Excel adds a generic placeholder title or none at all. Let us replace it with something meaningful.

1. Click on your pie chart to select it
2. You will see "Chart Title" at the top of the chart
3. Double-click the title text to enter edit mode
4. Delete the placeholder text and type: 2025 Annual Marketing Budget
5. Click anywhere outside the title box to confirm

To change the title font or size:

• Click the title once to select it
• Use the Home tab to change font, size, bold, or color
• A bold, 14-point font works well for most presentation sizes

Read Also: What is Power Query?

How to Add Data Labels

Right now the chart shows five colored slices with no numbers on them. Data labels fix that immediately.

1. Click on your pie chart to select it
2. Click the + (Chart Elements) button at the top right corner of the chart
3. Check the box next to Data Labels
4. Excel will place the raw budget values on each slice (45000, 30000, 20000, 15000, 10000)

Those raw numbers are useful, but percentages tell a clearer story for a budget chart. Here is how to show percentages instead:

1. Right-click any data label on the chart
2. Click Format Data Labels
3. A panel opens on the right side of your screen
4. Under Label Contains, check both of these:
   • Category Name (shows Department names like Digital Ads, SEO, etc.)
   • Percentage (shows 37.5%, 25%, 16.67%, etc.)
5. Uncheck Value so the raw dollar numbers do not clutter the labels

Each slice will now read something like Digital Ads, 37.5% — giving your reader both context and proportion without any extra effort.

To move a label that overlaps another:

• Click a label once to select all labels at the same time
• Click the overlapping label a second time to select just that one
• Drag it to a cleaner position

Related Article: XLOOKUP() vs. VLOOKUP()

How to Change Slice Colors?

The default Excel colors are fine, but you can match your company brand or presentation theme.

To change one specific slice (for example, the Digital Ads slice):

1. Click anywhere on the pie to select all slices
2. Click the Digital Ads slice a second time to select only that slice
3. Right-click and choose Format Data Point
4. In the panel on the right, click Fill
5. Click Solid Fill, then click the color box to pick a new color

For example, make the Digital Ads slice your company's primary brand color since it is the largest and most important segment in the budget.

To change all colors at once using a theme:

1. Click the chart
2. Go to the Chart Design tab in the ribbon
3. Click Change Colors
4. Browse the palettes and click one to apply it instantly

How to Edit the Legend?

The legend shows which color corresponds to which department. By default, Excel places it at the bottom of the chart.

To move the legend:

1. Click the + (Chart Elements) button
2. Hover over Legend
3. Click the small arrow to its right
4. Choose: Top, Bottom, Left, or Right

For our marketing budget chart, placing the legend on the Right works well. If your slices already show department name labels, you can remove the legend entirely to reduce visual clutter.

To remove the legend:

1. Click the + button
2. Uncheck the Legend box

Also Read: How to Remove Spaces in Excel?

Advanced Chart Options for Better Visuals

These options let you handle special scenarios and create more impactful presentations with our marketing budget data.

How to Create an Exploded Pie Chart?

An exploded pie chart pulls one or more slices away from the center. This is useful when you want to draw attention to a specific department — for example, highlighting that Digital Ads takes 37.5% of the entire budget.

To explode just the Digital Ads slice:

1. Click the pie chart once to select the whole pie
2. Click the Digital Ads slice a second time to select only that slice
3. Slowly drag the slice outward away from the center
4. Release the mouse when the separation looks right

To explode all five slices equally:

1. Right-click the pie with the whole pie selected (not a single slice)
2. Click Format Data Series
3. Under Series Options, find the Pie Explosion slider
4. Drag it to the right — 10% to 20% looks clean without being overdone

How to Create a Pie of Pie Chart?

Imagine you added three more small items to our marketing budget: Sponsorships ($3,000), Affiliate ($2,500), and Print ($2,000). Those tiny slices would be nearly invisible in the main pie.

A Pie of Pie chart solves this by grouping the small slices into a secondary pie next to the main one.

1. Add the three new rows to your data (A7:B9)
2. Select your full updated range (A1:B9)
3. Go to Insert > Pie Chart
4. Click Pie of Pie from the dropdown

Excel will automatically move the smallest slices into a secondary pie on the right side.

To control which slices go into the secondary pie:

1. Right-click the main pie
2. Click Format Data Series
3. Under Split Series By, choose one of:
   • Position – moves the last N slices to the secondary pie
   • Value – moves any slice below a dollar threshold you set
   • Percentage Value – moves any slice below a percentage you set
   • Custom – you manually decide which slices go where

For our extended data, setting Value to less than $5,000 would automatically move Sponsorships, Affiliate, and Print into the secondary pie

Read Also: Top 10 In-Demand Microsoft Certifications

How to Create a Bar Pie Chart?

The steps are identical to Pie of Pie:

1. Select your full data range
2. Go to Insert > Pie Chart
3. Click Bar of Pie instead of Pie of Pie

The small slices (Sponsorships, Affiliate, Print) will appear in a bar chart on the right side. Many readers find this easier to compare than two circular charts next to each other.

How to Rotate the Pie Chart?

By default, Excel starts the first slice (Digital Ads) at an arbitrary angle. Rotate it so the largest slice starts at the 12 o'clock position for a cleaner, more professional look.

1. Right-click the pie and click Format Data Series
2. Under Series Options, find Angle of First Slice
3. Type 0 to start Digital Ads at the very top (12 o'clock)
4. Or type any number between 0 and 360 to rotate to a custom position

How to Show Percentages in a Pie Chart?

Showing percentages instead of raw dollar values often tells a clearer story. For our marketing budget, "Digital Ads takes 37.5% of the budget" is more immediately meaningful than "Digital Ads gets $45,000."

Method 1: Add Percentage Labels Through Chart Elements

1. Click on your pie chart
2. Click the + (Chart Elements) button
3. Hover over Data Labels and click the small arrow to the right
4. Click More Options
5. The Format Data Labels panel opens on the right
6. Under Label Contains, check Percentage
7. Uncheck Value

Your five slices will now show: 37.5%, 25%, 16.67%, 12.5%, 8.33%

Method 2: Format Data Labels Directly

If you already have labels on your chart:

1. Right-click any existing data label
2. Click Format Data Labels
3. Check Percentage and uncheck Value

Related Article: Pivot Table in Excel

How to Show Both Department Name and Percentage

This combination is the most useful for our marketing budget chart. It gives your reader both the context (which department) and the proportion (what percentage) in one label.

1. Open Format Data Labels using either method above
2. Check Category Name and Percentage
3. Uncheck Value

Each slice will now read: Digital Ads, 37.5% and Content Marketing, 25% and so on.

How to Control Decimal Places in Percentages?

Excel defaults to one decimal place (37.5%). To change this:

1. In the Format Data Labels panel, scroll down to Number
2. Select Percentage from the Category list
3. Set Decimal Places to 0 for clean round numbers (38%) or keep it at 1 for one decimal place (37.5%)

For a boardroom presentation of our marketing budget, 0 decimal places looks cleanest. For a detailed financial report, 1 decimal place gives more precision.

Common Errors and Fixes

Even experienced Excel users run into these problems. Here is how to fix each one using our marketing budget chart as an example.

Error 1: Chart Is Not Showing All Five Departments

Problem: Your pie chart shows three or four slices instead of five.

Fix:

1. Right-click the chart
2. Click Select Data
3. Check that the Chart Data Range shows Sheet1!A$1:B$6 (or your equivalent)
4. If it shows a shorter range, click inside the range box and update it to include all six rows
5. Click OK

Error 2: Budget Numbers Appear as Text Instead of Numbers

Problem: Your pie chart shows only one giant slice or looks completely wrong.

Fix:

1. Go back to your data on the worksheet
2. Select cells B2:B6 (your five budget values)
3. Look at the format dropdown in the Home tab under the Number group
4. If it says Text, click the dropdown and switch it to Number
5. Re-enter one value manually (type 45000 in B2 and press Enter) to trigger the conversion

Your chart will immediately update to show the correct five slices.

Error 3: Excel Is Treating "Budget (USD)" as a Data Point

Problem: Your chart has a sixth slice, or the legend shows "Budget (USD)" as a department name.

Fix:

1. Right-click the chart and click Select Data
2. Make sure your range starts at A1, not A2
3. Excel should auto-detect header lines. If it does not, look for a My data has headers checkbox and enable it
4. Click OK

Also Read: KPI in Power BI: Key Performance Indicators Dashboards

Error 4: Department Name Labels Are Overlapping

Problem: Labels for small slices like PR & Outreach (8.33%) and Events (12.5%) are sitting on top of each other because those slices are too narrow.

Fix:

1. Click a label once to select all labels
2. Click the PR & Outreach label a second time to select only that one label
3. Drag it outward to a clear area of the chart
4. Or switch to Data Callout style: click the + button, hover over Data Labels, click the arrow, and select Data Callout — this adds a connector line so labels can sit outside the pie without touching each other

Error 5: Chart Does Not Reflect Updated Budget Numbers

Problem: You changed the Digital Ads budget in cell B2 from 45000 to 50000, but the chart did not change.

Fix:

1. Right-click the chart and click Select Data
2. Confirm the Chart Data Range still points to A1:B6
3. If the range is correct, go to Formulas > Calculation Options > Automatic
4. Press F9 to force a manual recalculation

The chart should now reflect the updated budget.

Error 6: Two Slices Look Almost the Same Color

Problem: The SEO ($20,000) and Events ($15,000) slices are too similar in shade to tell apart at a glance.

Fix:

1. Click the chart
2. Go to Chart Design > Change Colors
3. Pick a palette that uses clearly distinct colors
4. Or click each slice individually and manually assign colors that are obviously different from each other

Best Practices for Using Pie Charts in Excel

Follow these rules and your marketing budget pie chart, or any pie chart you ever build, will always look clean, professional, and easy to read.

1. Keep It to 5 to 7 Slices Maximum

Our marketing budget has five departments, which is ideal. If you later add 10 more budget line items, do not show all 15 as separate slices. Group anything under 3% of the $120,000 total into one "Other" slice. Use a Pie of Pie chart if you need to preserve the detail of those small categories.

2. Always Start the Largest Slice at 12 O'Clock

For our chart, Digital Ads is the largest slice. Start it at the top by setting the Angle of First Slice to 0 in Format Data Series. This follows the natural reading direction and helps your audience immediately identify the dominant category.

3. Put Labels Directly on the Slices

Do not force your reader to look at the legend and then back at the chart. Show Category Name + Percentage directly on each slice. Your reader should understand what each slice means without looking elsewhere.

4. Use a Descriptive Title

The title "Chart 1" says nothing. The title "2025 Annual Marketing Budget by Department" tells the full story. Write a title that answers this question: "What is this chart about?"

5. Avoid 3-D Unless You Have a Specific Reason

In a 3-D view of our budget chart, the Digital Ads slice at the front of the 3-D perspective appears even larger than its actual 37.5%. This can mislead your audience into overestimating how dominant one department is. Stick with 2-D for accuracy.

6. Use Contrasting Colors for Adjacent Slices

In our chart, do not place two blue shades next to each other. If Digital Ads is dark blue, make Content Marketing orange or green so the boundary between slices is immediately clear.

7. Sort Your Data Before Building the Chart

Sort your budget data from largest to smallest before inserting the chart. This way, slices appear in a logical descending order starting from 12 o'clock.

To sort: select A1:B6, go to Data > Sort, sort Column B from Largest to Smallest. Digital Ads ($45,000) will move to row 2 and the chart will plot slices in that clean descending order.

Read Also: Excel Certifications

Excel Pie Chart Alternatives

Sometimes a pie chart is not the right tool, even for clean budget data like ours. Here are the best alternatives and when to use each one.

1. Bar Chart

Use a bar chart when the differences between your department budgets are small and hard to see in a pie. If Digital Ads was $22,000 and Content Marketing was $21,000, those two slices would look almost identical in a pie chart. A bar chart makes the $1,000 difference clearly visible.

How to insert: Select A1:B6 > Insert > Bar Chart > Clustered Bar

2. Column Chart

Use a column chart when you want to present the same marketing budget data in a more traditional report format. Columns feel formal and are standard in financial presentations.

How to insert: Select A1:B6 > Insert > Column Chart > Clustered Column

3. Stacked Bar or Column Chart

Use a stacked chart when you want to compare the 2025 marketing budget against the 2024 budget, showing both the total and the department breakdown at the same time.

How to insert: Set up your multi-year data > Insert > Bar Chart > Stacked Bar

4. Treemap Chart

If your marketing budget had 15 departments instead of five, a treemap would handle that data far better than a pie chart. Each department gets a rectangle, and larger budgets get larger rectangles. No slices become too thin to read.

How to insert: Select A1:B6 > Insert > Hierarchy Chart > Treemap

Pie Chart vs Doughnut Chart

Both charts work with our exact same marketing budget data (A1:B6). Here is how they compare.

Which One Should You Choose?

Use a pie chart when you want the simplest, most universally understood view of your marketing budget.

Use a doughnut chart when you are building a modern dashboard and want to display the total budget figure ($120,000) prominently in the center.

Read Also: Excel ROUND(): A Quick Guide to Rounding in Excel

How to Update a Pie Chart Automatically

Your marketing budget will change throughout the year. New campaigns are approved, budgets reassigned. Here is how to make your pie chart update automatically without rebuilding anything.

Method 1: Convert Your Data to an Excel Table (Best Method)

1. Click anywhere inside your data range (A1:B6)
2. Press Ctrl + T (Windows) or Cmd + T (Mac)
3. The Create Table dialog will appear
4. Make sure My table has headers is checked
5. Click OK

Your data is now an Excel Table with a striped style. Now build your pie chart from this table. When you add a new department below the table, the chart will automatically grow to include the new slice.

To add a new department (for example, Podcast with a $5,000 budget):

1. Click cell A7 (the first empty cell below PR & Outreach)
2. Type Podcast
3. Press Tab and type 5000 in B7
4. Press Enter

Your pie chart will immediately update to show a sixth slice for Podcast.

Method 2: Expand the Data Range Manually

If you prefer not to use a Table:

1. Right-click your chart
2. Click Select Data
3. Under Chart Data Range, change the range from A1:B6 to A1:B7 (or whatever your new last row is)
4. Click OK

Method 3: Use a Named Range

This method makes your chart more resilient to structural changes in the spreadsheet.

1. Select cells A2:A6 (your five department names, not the header)
2. Click the Name Box (the small white box to the left of the formula bar at the top)
3. Type Departments and press Enter
4. Select B2:B6 (your five budget values)
5. Click the Name Box again
6. Type Budgets and press Enter

Now when you edit the chart's data source, you can reference Departments and Budgets by name instead of fixed cell addresses. This is especially useful if you restructure your spreadsheet or add new sheets later.

Excel Pie Chart Shortcuts and Tips

These shortcuts and tips will save you significant time when working with your marketing budget chart or any pie chart in Excel.

Keyboard Shortcuts:

Related Article: How to Remove Blank Rows in Excel?

Wrapping Up

You now have a complete, step-by-step understanding of how to build, customize, and manage a pie chart in Excel, using one consistent marketing budget dataset from start to finish.

You started with five rows of raw data totaling $120,000. You built a standard 2-D pie chart, added department labels and percentages, changed colors, rotated the pie, and explored advanced options like Exploded Pie, Pie of Pie, and Doughnut charts. You also learned how to fix six common errors, set your chart up for automatic updates, and work faster with keyboard shortcuts and templates.

The key is always to keep things simple. Use pie charts when the data is proportional, the categories are manageable, and the differences are clearly visible. When the data gets too complex or the categories multiply, a bar chart or column chart will serve you better.

The best pie chart is the one your audience understands immediately. Build it clearly, label it honestly, and let the data speak for itself.

FAQs

Q1: How do I create a pie chart in Excel from a table?

Select your full table including headers (for our example, that is A1:B6), go to Insert > Pie Chart, and choose your chart type. Excel will automatically use your column headers as the series name and your department names as slice labels.

Q2: How do I show percentages instead of dollar values in an Excel pie chart?

Click your chart, click the + (Chart Elements) button, hover over Data Labels, click More Options, and check the Percentage box while unchecking the Value box. Your slices will then show 37.5%, 25%, 16.67%, and so on instead of raw dollar amounts.

Q3: Can I have two sets of data in one pie chart?

No, a standard pie chart only accepts one data series. If you want to compare the 2024 and 2025 marketing budgets in one chart, use a Doughnut chart with two rings, or create two separate pie charts side by side.

Q4: Why is my pie chart showing only one big slice?

This usually happens when Excel reads your budget values as text instead of numbers. Select cells B2:B6, go to Home > Number format, and change it from Text to Number. Then re-type one of the values (like 45000 in B2) and press Enter to force the conversion.