How to make a pie chart in Excel is one of the most common chart-creation questions for users wanting to visualize parts-of-a-whole relationships. Pie charts show how individual categories contribute to a total, with each slice representing one category sized proportionally to its share of the whole.
Whether you're presenting market share by competitor, expense breakdown by category, sales by region, survey responses by option, or any similar parts-of-a-whole data, pie charts provide intuitive visual representation that audiences quickly understand. The Excel pie chart feature has been refined across many versions to provide flexible chart customization with relatively simple creation workflow.
This guide walks through every aspect of creating effective pie charts in Excel — selecting appropriate data, choosing between standard pie chart types (basic pie, doughnut, pie of pie, bar of pie), customizing colors and labels, adding data callouts and percentages, and avoiding common pitfalls that produce misleading or hard-to-read pie charts. Information here applies to Excel 365, Excel 2019, Excel 2021, and Excel for the web with notes where features differ. Most operations work consistently across Windows and macOS with minor menu placement variations between platforms commonly encountered today.
Before creating any pie chart, consider whether pie chart is actually the right visualization. Pie charts work well for 2-7 categories with substantial size differences and where parts-of-whole is the key message. They work poorly for 8+ categories (slices become too thin to compare), categories with similar sizes (slices become indistinguishable), or trends over time (line charts work better). Bar charts often communicate the same parts-of-whole relationship more effectively than pies for many scenarios.
Critical readers like Edward Tufte and Stephen Few have written extensively about pie chart limitations — consider whether your specific data benefits from the pie format or whether alternatives serve better.
Quick steps: 1) Select data range including category labels and values. 2) Click Insert tab. 3) Click pie chart icon in Charts group. 4) Choose pie chart type (2-D pie, 3-D pie, doughnut, etc.). 5) Excel creates pie chart on worksheet. Customize: Click chart, use Chart Tools (Design and Format tabs) for styling. Add data labels: Click chart, click + button, check Data Labels for percentage display. Best for: 2-7 categories, parts-of-whole visualization. Avoid: Too many categories, similar-sized slices, or trends over time.
The basic process for creating a pie chart starts with properly structured data. Pie charts need two columns: one with category labels and one with numeric values representing each category's share of the total. For example, columns A and B with rows for 'Region' (East, West, North, South) and 'Sales' values.
Select both columns including the headers (or just the data range without headers if you don't have headers). Then click the Insert tab and find the Charts group. Click the pie chart icon (a circular pie chart symbol) to see chart type options. Choose 2-D Pie for the most common pie chart variant.
Excel immediately creates a pie chart positioned over your worksheet with each slice proportionally sized to its data value. The chart automatically uses your category labels as the legend and applies a default color palette. Excel calculates each slice's percentage of the total automatically — you don't need to convert your values to percentages first. The underlying data values can be raw numbers (sales dollars, response counts, expense amounts, etc.) and Excel handles the proportion calculations internally. Click and drag the chart to reposition it; click and drag the chart edges to resize it as needed for your worksheet layout.
Standard flat pie chart. Most common and most readable. Default starting choice.
Three-dimensional pie. Looks more elaborate but less precise for size comparisons. Use sparingly.
Pie chart with hollow center. Same data structure as pie. Center can hold totals or labels.
Main pie with secondary pie expanding small slices. Useful when small categories matter.
Main pie with secondary stacked bar showing small categories. Alternative to Pie of Pie.
Slices separated for emphasis. Use when calling attention to specific category.
Customizing pie chart appearance involves several common adjustments. Add data labels by clicking the chart, then clicking the + button (Chart Elements) on the chart's right side, and checking Data Labels. Click the small arrow next to Data Labels to access More Options including showing values, percentages, category names, or combinations. Choosing percentage display is most common — viewers see what percent each slice represents. Position labels using the position dropdown — Inside End is common, placing labels just inside each slice's outer edge. Best Fit positions labels for readability based on slice sizes.
Color customization follows several patterns. Excel applies a default color palette varying by current theme. To change colors, click the chart and use Chart Design tab → Change Colors dropdown for predefined palettes. For specific slice colors, click once to select the entire data series, click again on a specific slice to select just that slice, then right-click → Format Data Point → Fill to choose specific color. Use color thoughtfully — accessibility considerations suggest using colors distinguishable to colorblind viewers (avoid red/green together for primary distinctions, use sufficient contrast between adjacent slices).
Chart titles, legends, and other elements complete the customization. Click the chart, then click the + button to access all chart elements. Toggle Title (chart title above the pie), Legend (category list with color matching), and other elements as needed. Some elements like data table or axis don't apply to pie charts and may not appear. Format individual elements by right-clicking them and choosing Format options. The chart styling possibilities are extensive — combining color, labels, position, and various other adjustments enables a wide range of visual presentations matching your specific reporting needs and branding requirements.
Add labels: Click chart → + button → check Data Labels. Customize: Click arrow next to Data Labels → More Options. Choose: Show value, percentage, category name, or combinations. Position: Inside End, Outside End, Center, Best Fit. Format: Right-click label → Format Data Labels for font, color, number format. Tip: Percentage display is most common for pie charts.
Default palette: Excel applies theme-based colors automatically. Change palette: Chart Design tab → Change Colors. Specific slice: Click slice once to select series, click again to select single slice, right-click → Format Data Point → Fill. Accessibility: Choose colorblind-friendly palettes; avoid red/green only for distinctions; ensure sufficient contrast between adjacent slices.
Title: Chart Elements + → Chart Title. Click to edit text. Legend: + → Legend → choose position (Right, Top, Bottom, Left). Or: Show category names directly on slices via Data Labels with Category Name option, then turn off Legend for cleaner appearance. Best practice: Either legend OR labels with category names — not both.
For pie charts with categories that include very small slices alongside larger ones, the small slices become hard to read. Pie of Pie and Bar of Pie chart types address this by expanding the smallest slices into a secondary visualization. Insert tab → pie chart icon → Pie of Pie shows the main pie with one slice expanded into a secondary smaller pie showing detail.
Bar of Pie shows main pie with secondary stacked bar showing smallest categories. Both maintain main pie focus while preserving information about smaller categories that would otherwise be invisible due to slice size limitations in standard pie charts.
Doughnut charts (sometimes called donut charts in older sources) provide an alternative to standard pie charts with hollow center. Same data structure as pie charts produces doughnut variants. The hollow center can be used for displaying total values, descriptive text, or simply for visual variety. Some style guides prefer doughnuts because the hollow center makes the chart less visually heavy than solid pies. Both pie and doughnut serve identical analytical purposes; choose based on preference and the visual style of your overall report or presentation.
Exploded pie charts emphasize specific categories by separating slices from the main pie. To explode a specific slice, click once on the chart to select the data series, click again on the specific slice to select just that slice, then drag the slice outward from the pie center. The slice separates with a small gap. To explode all slices uniformly, right-click and choose Format Data Point → Series Options → Pie Explosion → set value (10-30% typical). Use exploded slices sparingly — they add visual emphasis but reduce overall pie cohesion when overused for many categories simultaneously.
For users wanting to convert existing pie charts to other chart types, Excel makes this straightforward. Click the chart to select it, then Chart Design tab → Change Chart Type. The dialog shows your current chart and other options. Choose any chart type for the same data — bar chart, column chart, line chart, etc. The data and labels stay the same; only the visual representation changes. This experimentation helps determine the best visualization for your specific data. Try multiple chart types to see which communicates your message most clearly before finalizing your report or presentation.
For users adding pie charts to PowerPoint presentations or Word documents, several integration approaches work. Copy the chart from Excel (Ctrl+C), paste into PowerPoint or Word (Ctrl+V). Excel offers paste options including Embed (chart maintains link to source data and updates), Picture (static image), and others. Embedded charts update when source Excel data changes; picture-paste creates static images that don't update. Choose embedding for ongoing-data scenarios where the chart should reflect updated values; choose picture for finalized presentations where data shouldn't change after creation.
For users wanting to use pie chart data outside Excel, several export options exist. Save Excel chart as image: right-click chart → Save as Picture → choose PNG, JPG, or other format. Export the entire workbook including charts: File → Export → Create PDF (preserves visual layout) or other formats. Embed in web pages: chart images work for static web display; for interactive web charts, consider tools like Power BI, Tableau, or web charting libraries that go beyond Excel's capabilities for online interactive presentations.
Common mistakes when making pie charts include several recurring issues that produce poor visualizations. Too many categories — pie charts with 10+ slices become unreadable as slice sizes shrink to imperceptible differences. Combine smaller categories into 'Other' before charting, or switch to bar chart for many categories. Similar-sized slices — when categories have similar values, slice size differences become invisible, defeating the visual purpose. Use bar charts for similar-sized categories where exact size matters more than approximate share comparisons.
Another common mistake is using 3-D pie charts for serious analytical work. The 3-D perspective distorts slice size perception, making angled slices appear larger or smaller than their actual values. The visual elaboration of 3-D doesn't improve comprehension and often impairs it. Stick with 2-D pie for analytical reports; reserve 3-D variations for casual presentations where visual style matters more than precision. Many style guides explicitly recommend against 3-D pie charts for any analytical purpose, regardless of how appealing the visual elaboration appears initially.
Comparing multiple pie charts for the same categories across different periods or groups is also problematic. Viewers struggle to compare slice sizes across separate pies. Stacked bar charts handle this much better, with bars representing different groups and segments showing category proportions within each. The same data plotted as multiple pies vs. stacked bars produces dramatically different communication effectiveness — almost always favoring the stacked bar format for cross-group comparison purposes when readers need to compare specific category proportions across multiple groups.
For users wanting to add pie charts to dashboards displaying multiple metrics, several considerations help. Size pie charts consistently across the dashboard — varying sizes implies different importance levels. Use consistent color palettes when categories repeat across multiple charts (sales by region appearing on multiple slides should use same color for each region throughout). Place pie charts thoughtfully — usually as supporting visualizations rather than primary metrics, given pie chart limitations for precise comparison. Combine with KPI cards or bar charts for the primary metrics, with pies for parts-of-whole context where appropriate.
For users automating pie chart creation through VBA macros, the basic pattern uses ChartObjects.Add with appropriate parameters. Set chart type to xlPie for standard pie. Set source data range. Apply formatting through chart properties. For repeatable workflows that produce similar pie charts across multiple datasets, VBA eliminates the manual point-and-click chart building required for each new chart. Charts can be created, formatted consistently, and positioned automatically on worksheets supporting reporting workflows that produce many similar charts efficiently across various data inputs.
For users wanting interactive pie charts beyond static Excel charts, several options exist. Power Pivot and Power BI provide interactive pie charts with hover details and drill-down capability. Form controls in Excel can drive chart updates based on user selections (combo box driving which data feeds the pie). Slicers connected to PivotTables and PivotCharts provide click-to-filter interactivity. For web-based interactive charts, libraries like Chart.js, D3.js, and Highcharts go beyond Excel for interactive presentations. Choose tool matching your audience and presentation context.
The bottom line on Excel pie charts: they work well for parts-of-whole visualization with 2-7 well-differentiated categories. Choose appropriate chart type for your data, structure data correctly, customize labels and colors thoughtfully, and consider whether pie chart actually serves your communication goals or whether alternatives like bar charts work better. With these practices, pie charts become useful tools for the specific scenarios they suit rather than overused defaults that produce ineffective visualizations across your reporting and presentation work.
Default choice for most parts-of-whole scenarios. Most readable and analytically clear.
Stylistic alternative to 2-D pie. Hollow center can hold total or descriptive text.
When you have important small categories alongside larger ones. Expands small slices.
Alternative to Pie of Pie. Some readers find bar layout for small categories clearer.
Emphasis on specific category by separating that slice. Use sparingly for most impact.
Generally avoid for analytical work — distorts slice perception. Casual presentations only.
For users wanting to share pie charts with non-Excel audiences, several formats work well. PNG image export provides high-quality static image suitable for documents and presentations. PDF export of the entire workbook preserves layout including charts. PowerPoint embedding maintains live data connection if you want updates to flow through. Web page export creates HTML with chart images embedded. Each format has trade-offs around editability, update behavior, and visual fidelity. Choose based on whether viewers need static finalized version (PNG, PDF) or dynamic updating version (embedded PowerPoint linked to Excel data).
For comparing pie chart effectiveness against bar chart alternatives, the empirical research is clear — bar charts almost always outperform pie charts for precise size comparison tasks. Studies asking participants to compare specific category sizes show consistently better accuracy with bar charts. The reason is human visual perception — we judge linear lengths more accurately than angular slice sizes. For reports where precision matters, default to bar charts even if pie charts feel more intuitive for parts-of-whole concepts. Reserve pie charts for situations where the parts-of-whole metaphor itself is the key message rather than precise size comparisons.
For users transitioning between Excel and other charting tools, pie chart concepts transfer with adjustments. Google Sheets has very similar pie chart capabilities. PowerPoint includes its own chart creation that's similar to Excel embedded charts. Tableau and Power BI handle pie charts but generally encourage other chart types for analytical purposes. Python's matplotlib creates pie charts via plt.pie(). R's ggplot2 supports pie charts though with some configuration complexity. The conceptual pie chart concept transfers across all these tools while specific implementation varies.
Looking forward, pie chart usage in business reporting continues evolving. Modern data visualization research increasingly favors bar charts and other alternatives over pie charts for most analytical purposes. Best-in-class business intelligence tools like Tableau and Power BI default to non-pie alternatives in many template defaults. Excel itself includes treemap and other newer chart types that handle multi-category data better than traditional pies. Adapt your reporting practices to current best practices rather than just creating pies because they're familiar — better visualizations often communicate your data more effectively to your audience.