How to Create a Pie Chart in Excel

A pie chart in Excel turns a column of numbers into a circle of slices, and that single visual change is often the difference between a spreadsheet that gets ignored and a report that gets approved.

If you have ever stared at a long list of sales by region, expense categories, or survey responses and wished readers could see the breakdown at a glance, this guide walks you through the exact clicks. You will learn how to prepare the data, insert the chart, label every slice clearly, swap to a doughnut or 3-D variant, and avoid the rookie mistakes that make pie charts misleading.

Most people pick up Excel charts by trial and error. That works, but it leaves gaps. You end up with slices that overlap, a legend nobody can read, or percentages that don't add to 100 because of hidden rows.

By the end of this article, you will know not just how to make a pie chart in Excel but when to use one, when to switch to a bar chart, and how to make it look polished enough for a board meeting. We tested every step in Excel 2019, Microsoft 365, and Excel for the web, and we flagged the spots where the menus differ.

If you are studying for a Microsoft Office Specialist certification or any workplace Excel test, charting questions show up in almost every exam. Get comfortable with pie charts and you will pick up easy points. Practice the skill on real data, then test yourself with the Microsoft Excel Creating and Managing Charts quiz to lock the knowledge in. Ready? Let's start with the basics: what your data needs to look like before you click Insert.

Before You Insert: Get Your Data Right

A pie chart shows parts of a whole. That means your data has to follow two rules, and almost every broken chart in the world breaks one of them. Rule one: you need exactly two columns. The first column holds the category names (regions, products, months, departments). The second column holds the numbers (sales, costs, votes, percentages). Rule two: those numbers should add up to a meaningful total. If you try to plot data that doesn't represent a whole, like temperatures across cities or stock prices, the slices won't make sense, even if Excel happily draws them.

Open a fresh worksheet and type a small example. In cell A1 write "Region," in A2 "North," A3 "South," A4 "East," A5 "West." In B1 write "Sales," then in B2 through B5 enter 12000, 8500, 15000, and 9500. That's all you need. No need to add a total row at the bottom because Excel computes percentages automatically. If your data has a totals row, exclude it from your selection or your chart will include a giant slice labeled "Total" that doubles every other slice's apparent share.

Check for hidden rows too. If you filtered a table earlier and forgot to clear the filter, the hidden rows still get plotted by default, which makes your percentages look wrong. Click the Data tab and choose Clear to remove any active filters before charting. For more table cleanup tips, the Excel filter guide covers the toolbar in detail.

Step-by-Step: Insert the Pie Chart

Highlight the range A1:B5 (categories and values together, including headers). Make sure the headers are in the selection so Excel can use them as labels automatically. Click the Insert tab on the ribbon. In the Charts group you will see a small icon that looks like a pie slice; it usually sits between the column chart and line chart icons. Click that icon and a dropdown opens with five options: 2-D Pie, 3-D Pie, Pie of Pie, Bar of Pie, and Doughnut.

For most reports, choose the first option, 2-D Pie. Excel drops a chart into the middle of your worksheet, sized roughly 3 inches square. The chart includes a title pulled from your second column header ("Sales" in our example), a legend on the right showing the four regions, and four slices sized in proportion to the numbers. That's the whole insertion process. From data to picture in three clicks: Insert, Pie icon, 2-D Pie.

If you accidentally clicked the wrong chart type, you don't need to delete it and start over. Right-click the chart border, choose Change Chart Type, and pick a new one from the dialog. Your data link stays intact. This swap-friendly workflow is the same approach used when converting between chart families like turning a column chart into a line graph in Excel for time-series data.

Add Data Labels So Readers Can Actually Read It

By default the new pie chart shows only a legend and the slices. People reading the chart have to match colors in the legend to slices in the pie, which is annoying. Fix this by adding data labels. Click anywhere on the pie to select it, then click the plus icon that appears at the chart's top-right corner. A small Chart Elements menu pops up. Check the Data Labels box. Excel writes the values onto each slice instantly.

To show percentages instead of raw numbers, hover over Data Labels in that same menu and click the small arrow to the right. Choose More Options. The Format Data Labels pane opens on the right side of your window. Check "Percentage" and uncheck "Value" if you want only percentages, or check both for a label that shows "12000 (28%)". You can also check "Category Name" so each slice is labeled with the region directly, letting you delete the legend for a cleaner look.

If labels overlap because two slices are tiny, drag a label outward. Excel draws a leader line connecting the label back to the correct slice. This trick is invaluable when one or two slices are under 5% and would otherwise be illegible. For consistency, set the label font size to 11 or 12 points in the Home tab; the default 9 is hard to read in printed reports.

Style, Colors, and Exploded Slices

Excel ships with about 20 prebuilt chart styles you can apply with one click. With the chart selected, look at the Chart Design tab on the ribbon. The middle section called Chart Styles displays thumbnail previews. Hover over each to preview live on your pie, then click to apply. Most thumbnails change the slice borders, label position, and shadow. Style 6 is a clean two-tone look popular in corporate decks. Style 11 is the high-contrast version often used in print.

Colors are controlled separately. Below the styles is a Change Colors button. Click it to open a palette of color schemes. Excel groups them as Colorful (different hue per slice) and Monochromatic (shades of one hue). For dashboards, monochromatic palettes tie better to a brand. To pick custom colors, click a slice once to select all slices, click the same slice again to select just that slice, then right-click and choose Format Data Point. The color picker accepts hex codes, so paste your brand color exactly.

An exploded slice pulls one or more pieces away from the center for emphasis. Click the chart, click once on the slice you want to explode, then drag it outward with the mouse. Excel pulls it out and the other slices stay in place. Use this to draw attention to a single category, like the highest-selling region. Don't explode every slice, that defeats the purpose and makes the chart look messy.

Title, Legend, and Layout Polish

By default the chart title says "Sales" or whatever your value column header is. That's rarely descriptive enough. Click the title text once to select the title box, click again to enter edit mode, then type something like "Q1 2026 Sales by Region". Press Enter or click outside to commit. For a longer subtitle, you can't add a true subtitle in Excel pie charts, but you can paste a text box from Insert > Text Box and position it below the title.

Legends sit on the right by default. Move the legend to the top or bottom by clicking it once, then dragging. Or click the plus icon, hover over Legend, click the arrow, and choose Top, Bottom, Left, or Right. If your data labels show category names directly on each slice, delete the legend entirely (click it and press Delete) for a cleaner chart.

Resize the chart by dragging the corner handles. Hold Shift while dragging to keep the proportions square (a pie chart works best square). To position the chart precisely, right-click the chart border and choose Format Chart Area > Size and Properties. Set the height and width in inches or pixels. For dashboards, sizes around 4 by 4 inches read well at typical zoom levels.

When NOT to Use a Pie Chart

Pie charts are popular but overused. They work well when you have three to six categories and the slices are visually distinct. They fail in three common scenarios. First, when you have many small categories, the slices become tiny wedges that nobody can read or compare. Second, when slices are similar in size, the eye can't tell which is biggest. Third, when you want to track change over time, a pie cannot show trends. In each case, choose a different chart.

For more than six categories, use a bar chart or column chart. The Excel Insert tab has both. Bars are easier to compare because the length of each bar maps directly to value. For tracking change over time, use a line chart, which shows trajectory and helps spot trends. To compare parts across time, a stacked column or stacked area chart is the right answer. Switching chart types in Excel is risk-free: right-click the chart, choose Change Chart Type, and pick something else. Your data stays the same.

Doughnut charts can be a smart alternative when you want to show the same data alongside additional info in the center hole, like a total or a percentage. To convert a pie to a doughnut, change the chart type as above and pick Doughnut. Then click on the doughnut, open Format Data Series, and adjust the Doughnut Hole Size between 10% and 90% depending on how much space you want in the middle.

Saving, Printing, and Reusing Your Chart

To save the chart as an image for use in PowerPoint, Word, or email, right-click the chart border and choose Save as Picture. Excel offers PNG, JPG, GIF, and SVG. PNG is the best default; it preserves transparency and stays crisp at any zoom level. SVG is excellent if the recipient will resize the chart, because it scales without losing quality, but older versions of Office may not display it correctly.

To print the chart on its own page, click the chart once to select it (don't double-click into it), then press Ctrl+P (Cmd+P on Mac). Excel offers a print preview showing only the chart. To print the chart along with the data, click outside the chart first, then print as normal; the chart will appear in its current position on the worksheet.

If you build pie charts often, save the formatting as a template. Right-click any finished chart and choose Save as Template. Give it a name. Next time, click Insert > Charts > All Charts > Templates and your saved template appears. Apply it to new data instantly. This saves hours when you build weekly or monthly reports with the same look.

Putting It All Together

Creating a pie chart in Excel takes three clicks, but creating one that actually communicates takes a few more decisions. Start with clean two-column data sorted from largest to smallest. Insert a 2-D pie unless you have a specific reason to choose another variant. Add data labels with category names and percentages so readers don't need to bounce between the legend and the slices.

Pick colors that match your brand or use a colorblind-friendly palette. Title the chart with a clear description and time period. Skip the 3-D effects, skip the 12-slice rainbows, and skip the negative numbers. When a pie chart isn't the right choice, swap it out for a bar chart in two clicks via Change Chart Type.

The same data, different picture, and your reader thanks you. If you build pie charts weekly, save your favorite styling as a template and reapply it every time. The hour you spend setting up a template pays back across every report for the rest of the year. Track which chart styles your stakeholders respond to and standardize on those across your team.

Charts are one of the most-tested skills on Microsoft Office Specialist exams and many workplace Excel assessments. Keep practicing on real data and you will get faster every time. Try writing yourself a weekly drill: pick a fresh data set, build a pie, then build the same data as a bar chart, and pick which one tells the story better.

When you are ready to test yourself, try the Excel charts quiz linked above, then move on to broader Excel skills like Excel formulas and how to create a pivot table. Each new skill compounds with the rest, and pretty soon a blank spreadsheet stops looking intimidating and starts looking like an opportunity.

One more tip many guides skip: name your chart. Click the chart, then look at the Name Box on the far left of the formula bar. You will see something like Chart 1. Type a descriptive name like SalesPie_Q1 and press Enter. This matters when you have multiple charts on one sheet and you want to reference them in a macro or jump to them via the Name Box. It also keeps your workbook tidy when you copy charts between files.