How to Insert a 2D Pie Chart in Excel

A pie chart is one of the simplest ways to show how different parts make up a whole. If you need to visualize your company’s market share, the breakdown of a marketing budget, or the results of a simple survey, an Excel pie chart gets the job done cleanly and clearly. This article will walk you through, step-by-step, how to prepare your data, create a 2D pie chart, and customize it to make your data easy to understand.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

When to Use a Pie Chart (and When to Pass)

Before you build one, it's important to know if a pie chart is even the right choice for your data. They are perfect for some situations and completely wrong for others. Using the right chart makes your data shine, the wrong one just creates confusion.

Use a Pie Chart When:

• You are showing proportions or percentages. The core function of a pie chart is to display a part-to-whole relationship. Each slice represents a percentage of the total.
• You have a small number of categories. Pie charts are easiest to read when they have six or fewer slices. More than that and the chart becomes cluttered and difficult to interpret.
• Your categories add up to a meaningful total (100%). The data must represent distinct parts of a single, collective whole. For example, the different sources of website traffic (Organic, Social, Direct, Referral) add up to 100% of your total traffic.

Avoid a Pie Chart When:

• You need to show changes over time. A pie chart represents a single point in time. To show trends, use a line chart or a column chart instead.
• You are comparing multiple data sets. Trying to compare the slices of two or more pie charts side-by-side is difficult and not very accurate for your audience. A grouped bar chart is a much better alternative for this.
• Your categories have very similar values. If your slices are nearly the same size, it’s almost impossible for the human eye to tell the difference. A simple bar chart would show these slight variations much more clearly.
• You have many categories. As mentioned, a pie chart with ten different tiny slivers is more confusing than helpful. In these cases, it's better to group the smallest categories into an "Other" slice or use a bar chart sorted from largest to smallest.

Preparing Your Data for a Pie Chart

The secret to creating any chart in Excel is structuring your data properly first. Excel is smart, but it needs your data organized in a way it understands. For a pie chart, this is incredibly simple.

You need just two columns of data:

1. Category Column: This column contains the labels for each slice of your pie (e.g., "Email Marketing," "Paid Social," "Organic Search").

2. Value Column: This column contains the numbers corresponding to each category (e.g., the budget amount, the number of sales, or website sessions).

Here’s an example of how you might set up data for a marketing budget breakdown:

Imagine your data looks like this in Excel:

This simple, two-column format with headers is perfect. Excel will automatically do the math to figure out what percentage of the total budget each channel represents.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Guide to Inserting a 2D Pie Chart in Excel

Once your data is properly formatted, creating the chart itself takes just a few clicks. Let's use our marketing budget example to build one.

Step 1: Select Your Data

Click and drag your mouse to highlight the entire data range you want to include in the chart. In our example, you would select cells A1 through B6, making sure to include the headers ("Marketing Channel" and "Monthly Budget"). Including headers helps Excel automatically label your chart correctly.

Step 2: Navigate to the Insert Tab

At the top of the Excel window, click on the Insert tab in the ribbon.

Step 3: Choose the Pie Chart Icon

In the "Charts" group on the Insert tab, look for the small icon that looks like a pie chart. Click on it to open a dropdown menu of chart options.

Step 4: Select the 2D Pie Chart

You'll see a few options, including 2D Pie, 3D Pie, and Doughnut. For clarity and data accuracy, the classic 2D Pie is usually your best bet. 3D charts can distort the visual size of the slices, potentially misleading your audience. Click on the first 2D Pie option.

Instantly, Excel will generate and insert a basic pie chart onto your spreadsheet. That's it! You’ve created the chart. Now, let’s make it look great and easy to read.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Customizing Your Pie Chart for Maximum Impact

A basic pie chart is good, but a well-customized one is great. Excel gives you tons of options to make your chart more informative and visually appealing. When you click on your new chart, two new tabs will appear in the ribbon: Chart Design and Format. These are your command centers for customization.

Add a Clear and Descriptive Title

The default title will likely be something generic like "Monthly Budget." That’s okay, but we can do better. Click directly on the chart title to edit the text. A better title would be something like "Monthly Marketing Budget Allocation" or "Marketing Spend by Channel - Q3." Be specific so anyone looking at the chart knows exactly what they're seeing.

Add Data Labels to Show Values or Percentages

A pie chart without labels is just a colored circle. You need to show your audience what each slice represents. This is the single most important customization you can make.

1. Click on your chart to select it.
2. A small plus sign (+) icon will appear on the top-right corner. This is the Chart Elements button. Click it.
3. In the menu that appears, check the box next to Data Labels.

By default, Excel might just add the numerical values. But for a pie chart, percentages are usually more powerful. To change what the labels show:

• In the Chart Elements menu, hover over Data Labels and click the small arrow that appears to the right.
• Select More Options... This will open up the "Format Data Labels" pane on the right side of your screen.
• Under "Label Contains," you can check the boxes for what you want to see. The best combination for a pie chart is usually Category Name and Percentage. You can uncheck "Value" to keep it clean.

Refine Colors and Style

Don't settle for the default blue-and-orange color scheme if it doesn't fit your needs.

• Quick Styles: With your chart selected, go to the Chart Design tab. The "Chart Styles" gallery offers a variety of pre-made designs with different backgrounds, label placements, and effects. It's a great way to find a professional look in seconds.
• Change Colors: Next to the styles gallery on the Chart Design tab is a "Change Colors" button. Here, you can select from a range of color palettes, including monochromatic, analogous, and colorful themes. Try to pick one that provides good contrast between adjacent slices.
• Coloring a Single Slice: To highlight one specific slice (e.g., your highest-spend category), you can change its color individually. First, click once on the pie to select the entire chart. Then, click a second time on just the slice you want to change. Now, with only that slice selected, go to the Format tab and use the "Shape Fill" option to pick a new color.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

"Explode" a Slice for Emphasis

If you want to draw special attention to one data point, you can "explode" it, which means pulling it slightly away from the rest of the pie.

To do this, click the chart once to select all slices, then click again on the one slice you want to emphasize. Now, with just that single slice selected, click and drag it a little bit away from the center of the pie. This is a great visual trick to guide your audience's focus.

Common Mistakes to Avoid

Finally, a few quick reminders on what not to do to keep your pie charts effective and honest.

• Slicing it Too Thinly: Avoid using more than six slices. If you have many small categories, group them into a single "Other" category to keep the chart clean.
• Using Misleading 3D Effects: It might look fancy, but the tilting and perspective of a 3D pie chart distorts the data. Slices in the foreground appear larger than they are, while those in the background appear smaller. Stick to 2D for accurate visual representation.
• Forgetting About an "Other" Slice: If you do consolidate smaller pieces into an "Other" slice, make a note somewhere (like a subtitle or footnote) what that slice consists of, so you are being fully transparent with your data.

Final Thoughts

Creating a 2D pie chart in Excel is a straightforward process once your data is properly structured. They remain a powerful way to show proportional data at a glance, and with Excel's customization tools, you can easily transform a basic chart into a clear and compelling visual for your reports and presentations.

While mastering charts in Excel is a great skill, sometimes the hardest part is just getting all your data in one place to begin with - especially if it's scattered across platforms like Shopify, Google Analytics, and Facebook Ads. We built Graphed to solve exactly this problem. As your AI data analyst, you can connect your data sources in seconds and simply ask a question in plain English, like "Show me a pie chart of our sales by product category from Shopify last month," and get back a live, interactive chart instantly. It handles all the data pulling and visualization for you, so you can spend less time wrangling data and more time finding insights.