How to Add Category Name in Excel Pie Chart

A pie chart without labels is just a colorful circle. While it might look nice, it tells your audience absolutely nothing. To turn that decoration into a useful data visualization, you need to add context - starting by labeling each slice with its category name. This article will walk you through exactly how to add category names, percentages, and values to your Excel pie charts, making them clear and instantly understandable.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Labels Are Essential for a Good Pie Chart

The entire point of a pie chart is to show the relationship of parts to a whole. Each slice represents a percentage of the total. Without labels, your readers are left guessing what each color-coded slice stands for. Are they looking at sales by region? Website traffic by source? Project budget by department?

Relying on a legend off to the side forces viewers to look back and forth, trying to match colors to categories. This is inefficient and can be frustrating. Placing the category name and its corresponding value or percentage directly on the chart makes the information immediate. It removes the guesswork and allows anyone to understand the data at a glance.

Adding direct labels also helps in situations a legend can't solve:

• Clarity: When two colors are very similar, a legend can be confusing. A direct label eliminates any ambiguity.
• Accessibility: For people with color vision deficiencies, a color-coded legend is often unusable. Direct labels make your charts accessible to everyone.
• Focus: Tucking all the essential information onto the chart itself keeps the viewer’s attention focused, making your point more effectively.

Simply put, labeling is not an optional polish, it’s a necessary step to make your chart do its job.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready

Before you even think about making a chart, a moment of preparation can save you a lot of headaches. Excel is smart, but it works best when your data is organized in a simple, structured way. For a pie chart, you need two columns: one for your categories and one for their corresponding values.

Make sure your data table has a clear header row. This helps Excel understand what to use for the chart title and labels. Your ideal setup looks like this:

Notice a few things here:

• Column A contains the text labels (categories).
• Column B contains the numerical values.
• There are no empty rows or columns within the data range.

Getting this structure right from the start is the key to creating a chart effortlessly.

Step 2: Create Your Pie Chart

With your data neatly organized, creating the initial pie chart is the easiest part.

1. Click and drag to select the entire data range, including the headers. In our example, you would select cells A1 through B6.
2. Go to the Insert tab on the Excel ribbon.
3. In the Charts section, click on the icon that looks like a pie chart ("Insert Pie or Doughnut Chart").
4. A dropdown menu will appear with different chart types. For now, choose the first option under 2-D Pie.

Just like that, Excel will drop a new pie chart onto your worksheet. You'll see the color-coded slices and a legend on the side. Now, it’s time to add the category labels directly onto the chart itself.

Step 3: Add and Customize Your Data Labels

This is where you bring your chart to life. There are a few ways to add data labels, but the most intuitive method in modern versions of Excel is using the "Chart Elements" button.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Fastest Way: The Chart Elements Pop-Up Menu

When you click on your new pie chart, three small icons will appear on the top-right corner. We are interested in the plus sign (+), which is the Chart Elements button.

1. Click on your pie chart to select it.
2. Click the plus sign (+) icon that appears on the right. A list of chart elements like "Chart Title" and "Legend" will show up.
3. Check the box next to Data Labels.

As soon as you check the box, Excel will add the numerical values to each pie slice. But we want more than that. We want the category names!

1. Hover over Data Labels and click the small arrow that appears to the right. This opens a new submenu.
2. Select More Options... at the bottom of that menu.

This will open up the Format Data Labels pane on the right side of your screen. This is your command center for customizing labels.

Under Label Options, you'll see a section called Label Contains with several checkboxes:

• Category Name: This is the one we want! Check this box to add the name of each slice (e.g., "Organic Search," "Direct").
• Value: This is checked by default and shows the number from your data table (e.g., "4,500"). You can keep it or uncheck it depending on your needs.
• Percentage: This is extremely useful for pie charts. Check this box to show what percentage of the whole each slice represents. Excel calculates this for you automatically.
• Series Name: This adds the header of your value column (e.g., "Sessions"). It’s usually not necessary for a simple pie chart.

For the clearest result, try checking Category Name and Percentage, and then unchecking Value.

Below the checkboxes, look for the Separator dropdown. This lets you choose how you want to divide your label elements. For example, selecting "(New Line)" will place the category name on one line and the percentage on the line below it, which often looks much cleaner than having them side-by-side.

Customizing Label Position and Appearance

Still in the Format Data Labels pane, you can adjust where the labels appear. Look for the Label Position section.

• Center: Places the label smack in the middle of each slice.
• Inside End: Puts the label near the outer edge, but still inside the slice.
• Outside End: Positions the labels just outside each pie slice. This is often the best option for readability, as it prevents text from cramming into smaller slices. When you choose this, Excel will automatically add Leader Lines connecting the label to its slice.
• Best Fit: Lets Excel decide where to place each label. This can work well, but you have less control.

Play around with these options to see what looks best for your specific chart. For a clean, professional look, Outside End is a fan favorite.

Troubleshooting Common Label Issues

Sometimes things don't go exactly as planned. Here are a few common issues and how to fix them quickly.

"My Labels are Overlapping or Hard to Read"

This is the most common problem, especially with pie charts that have many small slices.

• Change the Label Position: Your first move should be to change the label position to Outside End. This gives each label its own space and uses leader lines to keep things clear.
• Resize the Chart: It might just be an issue of space. Click and drag the corner of your chart to make it larger. This gives all the elements more room to breathe.
• Consider Another Chart Type: A pie chart becomes less effective with more than 5-7 slices. If you have too many categories, the chart becomes a mess of tiny slivers with crammed labels. In this case, a Bar Chart is a much better choice for comparing categories.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"How Do I Remove the Legend?"

Now that your labels are directly on the pie slices, the legend on the side is redundant and just taking up space.

1. Click your chart to select it.
2. Click the Chart Elements (+) button again.
3. Uncheck the box next to Legend.

This instantly frees up space, allowing your chart to be larger and more prominent.

"My Category Names Look Wrong or Show Up as Numbers"

This usually happens if your data wasn't selected correctly at the beginning.

• Double-check that you selected both the category column (Text) and the value column (Numbers) when you created the chart.
• If you did, try recreating the chart from scratch, carefully selecting the entire data range (including headers) before you go to Insert > Chart. Incorrect initial data selection is almost always the culprit.

Final Thoughts

Transforming a simple pie chart into a powerful communication tool is all about labeling it correctly. By adding category names and percentages directly onto the chart's slices, you make your data accessible and easy to digest for any audience. Move the labels outside the ends, remove the redundant legend, and you have a professional-looking chart that tells a clear story in seconds.

For many teams, manually creating and formatting these reports in Excel every week is a reporting ritual that eats up countless hours - especially if that data is coming from different platforms like Google Analytics or your e-commerce store. We built Graphed to automate that entire process. You can connect all your marketing and sales data sources in one place, and then just ask for the visualization you need in natural language. Instead of clicking through menus in Excel, you could ask, "Show me a pie chart of our Shopify sales by product category for last month," and we’ll build an interactive, live-updating chart for you instantly.