How to Create a Donut Chart in Excel: Hidden Data-Label Tricks for Clarity

Creating a donut chart in Excel isn't just about inserting a pie chart with a hole—it's about making your data pop with clarity. ✨ I remember my first time struggling with this in Dad's Pittsburgh scrap-yard workshop, where we'd sketch circuit diagrams on napkins.

The real trick lies in the data labels, which most tutorials gloss over.

Here's where most guides fail: they stop at the basic chart. But adding percentage labels inside the donut slices—without overlapping—requires a sneaky workaround using Excel's text box tools.

I've tested this across dozens of datasets, and the cleanest method uses one-click formatting after inserting the chart. The labels become your visual guide, not just decoration.

You'll end up with a chart that looks professional enough for board meetings but took less than five minutes to perfect. The labels stay crisp even when you hover, and you can color-code categories without sacrificing readability. This is the version I wish I'd seen back in that basement workshop.

Works for any version of Excel from 2013 onward, including Excel Online. The same technique applies whether you're visualizing market share, survey results, or even my infamous ThinkPad collection inventory. Let's make your data tell its story.

What you need

Step-by-Step instructions for crafting Excel donut charts with precision

Here's how to build a polished donut chart with professional data-label techniques.

Open Excel and create a clean data range with your categories in column A and values in column B. For example, label cell A1 as "Category" and B1 as "Value." I always use headers because they make chart creation intuitive and prevent label misalignment later.

Enter your data points below—each category should have one corresponding value. For instance, if tracking market share, you might list "Product A" with a value of 35, "Product B" with 45, and "Product C" with 20. Double-check that you have no blank rows between entries, as this can cause chart rendering errors.

Select your data range (including headers) by clicking and dragging from the top-left to bottom-right cell. Then, navigate to the Insert tab and click Insert Pie or Donut Chart. Choose Donut Chart from the dropdown menu. The chart will appear as a basic donut with no labels.

If your chart appears with no data, verify you selected the correct range—including headers. The donut chart requires headers to properly map categories to segments. You'll know it's correct when each segment corresponds to your data values visually.

Right-click any segment of the donut chart and select Add Data Labels. This adds basic labels, but we'll refine them. Click the + icon next to the chart to open the Chart Elements menu. Check Data Labels and uncheck Legend to focus on clarity.

For cleaner labels, right-click the chart again and choose Format Data Labels. In the pane that appears, set Label Position to Outside End and Label Separator to Comma Space. This ensures labels don't overlap segments. Here's the thing—this positioning works best for donuts with fewer than 5 segments.

With the chart still selected, go to the Chart Design tab and click Change Colors to apply a professional palette. For better readability, increase the donut hole size: right-click the chart, select Format Data Series, and under Series Options, set Donut Hole Size to 40%. This creates breathing room for labels.

To add percentages, right-click the chart, choose Add Chart Element, then Data Labels. In the Format Data Labels pane, check Percentage under Label Options. This displays each segment's proportion of the whole, which is critical for donut charts. Real talk: percentages make your chart instantly more informative.

Hover over each segment to confirm labels display correctly. If any label overlaps, adjust the Donut Hole Size incrementally (e.g., 35% or 45%) until all labels fit without crowding. For final polish, right-click the chart and select Save as Picture to export as a PNG with transparent background.

Test the chart in a presentation by resizing it—labels should remain crisp at 80% of original size. If labels blur, reduce the font size in Format Data Labels (e.g., to 10pt). You've got this: a clean, professional donut chart ready for any report.

Tips & tricks for perfect Excel donut charts

Here's what nobody tells you about crafting donut charts that actually look professional—not just functional. These tricks will transform your basic Excel visuals into polished data presentations that impress stakeholders.

Data Structure is Everything: In Step 1, when preparing your data range, consider adding a third column for custom labels if your categories are long or complex. For example, if "Product A" is actually "Enterprise Software Solutions," create a third column with abbreviated labels. This prevents label overflow in Step 3 when positioning outside the donut segments. I've seen presentations where truncated labels made the chart unreadable—don't let that be you.

Color Psychology Matters: When applying your professional palette in Step 4, avoid using more than 5 colors for donut charts. Excel's default color wheel can create visual chaos with too many hues. Instead, choose a harmonious palette where adjacent segments have similar color families but distinct enough to differentiate. For maximum impact, use your organization's brand colors—just ensure they have sufficient contrast against white backgrounds.

Hidden Trick for Label Clarity: After setting your donut hole size to 40% in Step 4, try this pro move: right-click the chart, select "Format Data Series," and under "Series Options," set "Donut Hole Size" to 35% for the first iteration, then incrementally increase to 45% while testing label readability. The perfect size depends on your segment count—this incremental testing prevents the common mistake of either too much white space or cramped labels.

Export Settings You Won't Find in Help: When saving your chart as a picture in Step 5, click the "Options" button in the Save As dialog and check "Transparent Background." This creates a PNG that blends seamlessly with any presentation background. Pro tip: Save two versions—one with transparent background for PowerPoint and one with white background for Word documents. The difference in professionalism is night and day.

Frequently asked questions

Got questions about crafting the perfect donut chart in Excel? You’re not alone—this visual tool is a favorite for comparing parts of a whole, but it can have quirks. Here are some common questions to help you troubleshoot and shine!

Wrapping up and next steps

Creating a donut chart in Excel is easier than you think—and with the right tricks, you can make it clear, professional, and visually engaging! 🎯 Whether you're tracking budgets, sales, or survey results, this chart helps highlight proportions in a snap.

Now that you’ve mastered the steps, go ahead and experiment with custom colors, dynamic labels, and even interactive elements to make your data pop.

Ready to take it further? Try animating your chart or embedding it in a dashboard for even greater impact. Your data deserves to shine—now get creating! ✨