How to Add Data to Pie Chart in Excel

Creating a pie chart in Excel is a fantastic way to visualize how individual parts contribute to a whole, but a chart without data is just an empty circle. This guide will walk you through exactly how to add, update, and display your data on an Excel pie chart, making your reports clear and impactful.

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

First, A Quick Note: When Should You Use a Pie Chart?

Before we build one, it's helpful to know the best time to use a pie chart. Pie charts shine when you are showing proportions or percentages of a total. Think of slicing up a pizza - each slice is a part of the whole pie. The best pie charts:

• Represent a single set of data (e.g., traffic sources for one month, not multiple months).
• Have fewer than seven categories or "slices." More than that and the chart becomes cluttered and hard to read.
• Use distinct parts that add up to 100%.

If you need to compare different datasets or show changes over time, a bar or line chart is usually a better choice. But for showing "share of a total," the pie chart is king.

Setting Up Your Data in Excel

A great chart starts with well-organized data. For a pie chart, Excel needs your data in a simple two-column or two-row format. One column/row should contain the names of your categories (the labels for your slices), and the other should contain the corresponding numeric values.

Let's use a common marketing example: tracking website traffic sources for a month. Your data should look something like this:

Column A: Source

• Organic Search
• Direct
• Paid Social
• Referral
• Email

Column B: Sessions

• 12,500
• 8,200
• 5,400
• 3,100
• 1,800

This simple layout makes it easy for Excel to understand which labels belong to which values, preventing any confusion when it creates your chart.

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

How to Make a Pie Chart and Add Data

Once your data is neatly arranged, creating the pie chart takes just a few clicks. This process inserts the chart and links it to your data source.

Step-by-Step Guide to Creating Your Chart:

1. Select Your Data: Click and drag your cursor to highlight the cells containing both your category names and values. In our example, you would select cells A1 through B6.
2. Go to the Insert Tab: At the top of the Excel ribbon, click on the Insert tab.
3. Choose the Pie Chart Icon: In the "Charts" section, you'll see a small icon that looks like a pie chart. Click on it.
4. Select a Chart Style: A dropdown menu will appear with several options like 2-D Pie, 3-D Pie, and Doughnut. For now, let's stick with a classic 2-D Pie. Click it to insert the chart into your worksheet.

Excel will automatically generate a pie chart complete with a title and a legend that corresponds to the colors of the slices. But you’ll notice something is missing: the actual numbers aren't on the chart itself!

Adding and Customizing Data Labels on the Chart

This is the most common reason people ask how to "add data to a pie chart." They want to see the values or percentages directly on the slices, making the chart easier to understand at a glance. Excel makes this incredibly easy.

1. Adding Basic Data Labels

With your new pie chart selected, you'll see a few icons appear on its top-right corner. Click the plus (+) icon, which is the Chart Elements button.

In the menu that appears, check the box next to Data Labels. Instantly, the numeric values from your data table will appear on their corresponding pie slices.

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

2. Customizing Your Data Labels for More Detail

Just showing the raw numbers is good, but often you'll want to display percentages or include the category names for even more clarity. To access these options, go back to the Chart Elements (+) menu and hover over Data Labels. Click the small arrow that appears to the right and select More Options...

A "Format Data Labels" pane will slide out on the right side of your screen. Under "Label Options," you have full control over what is displayed:

• Value: This is the default number from your data table (e.g., "12,500").
• Percentage: Excel will automatically calculate what percentage each slice represents of the total and display it. This is highly recommended for pie charts!
• Category Name: This will display the label for each slice (e.g., "Organic Search") directly on the chart, which often lets you remove the separate legend.
• Series Name: This is less common for pie charts but will show the name of the data series from your header (e.g., "Sessions").
• Show Leader Lines: If your labels are crowded, checking this box allows you to drag a label away from its slice, and a line will automatically connect it back.

You can mix and match these options. A popular and very clear combination is to check both Category Name and Percentage, then uncheck Value. This tells your viewer exactly what each slice is and its share of the total, which is the whole point of a pie chart.

Under "Label Position," you can also choose where the labels sit: Center, Inside End, Outside End, or Best Fit. Outside End is often the cleanest look, especially if you have several slices.

Updating Your Pie Chart with New or Changed Data

Your reports are rarely static. Data changes, and you'll inevitably need to update your chart. Thankfully, because the chart is linked to your source cells, this is a very simple process.

Scenario 1: A Value in Your Data Changes

Let's say you get updated numbers, and Organic Search traffic was actually 13,000, not 12,500. All you need to do is change the value in the cell.

Go to cell B2 and change "12,500" to "13,000," then press Enter. Your pie chart will instantly and automatically resize the slices to reflect the new proportions. You don’t have to do anything else!

Scenario 2: Adding a New Category to Your Data

What if a new traffic source appears, like "Organic Social," that you need to add to the chart? This requires one extra step.

1. First, add the new category and its value to your data table. For instance, add "Organic Social" in cell A7 and its value, say "950," in B7.
2. Next, click once on your pie chart to select it. You will see your original data range (A1:B6) highlighted with a blue box.
3. Move your cursor to the small square handle at the bottom-right corner of the blue box.
4. Click and drag that handle down one row to include your new data (A7:B7).

Once you release the mouse button, the chart will redraw itself to include the "Organic Social" slice and recalculate all the percentages. It's a simple drag-and-drop update that takes seconds.

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

Can You Add a Second Data Series to a Pie Chart?

This is a common question with a simple answer: no, you can't add a second data series to a standard pie chart. Remember, a pie chart is designed to show the parts of a single whole. Adding a second set of data (like website sessions from a different month) wouldn't make sense in one pie - it would be like trying to represent two different pizzas in one circle.

If you need to compare two data series, Excel has better tools for the job:

• Doughnut Chart: This is the closest alternative and looks like a pie chart with a hole in the middle. You can add multiple data series as concentric rings, which is great for comparing wholes (e.g., traffic mix this quarter vs. last quarter).
• Clustered Column Chart: This is an excellent way to compare categories across two different series, with bars side-by-side for easy comparison.
• Stacked Bar Chart: This lets you show the total of both series while also visualizing how each category contributes to that total.

Final Thoughts

Adding data to an Excel pie chart is all about starting with properly formatted source data and then using the Chart Elements menu to display labels like values, percentages, and categories. Now you know how to not only create a compelling pie chart from scratch but also how to easily update it as your data changes, keeping your reports fresh and accurate.

Eventually, the manual routine of exporting data from different sources like Google Analytics, Shopify, or HubSpot just to build charts in Excel becomes a bottleneck. We built Graphed to solve exactly this problem. Instead of wrestling with CSVs, you can connect your accounts and simply ask in plain English, "Create a pie chart showing my paid ad spend by campaign for last month." It builds the chart for you, and your dashboards stay updated automatically, giving you more time to act on insights and less time on manual reporting.