3D Pie Chart in Excel: How to Create and Format It

To create a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column list of category names and values, then choose Insert > Insert Pie or Doughnut Chart > 3-D Pie. Excel creates a chart showing each category as a slice of the total; you can then add labels, adjust its appearance, or change the angle.

Create a 3-D Pie Chart in Excel

A basic pie chart needs category labels and one column of numeric values. For example, a small shop might have a table with Product in A1, Units Sold in B1, and three product names and sales counts beneath those headings. Select the headings and data together, then insert the chart. Including the headings helps Excel identify the category names and series name.

Arrange the categories in one column and their values in the next, with a heading for each column.
Select the complete table, including headings. Avoid selecting unrelated totals or notes.
Open the Insert tab, select Insert Pie or Doughnut Chart in the Charts group, and choose 3-D Pie.
Select the chart title to replace it with a specific description, such as Units Sold by Product.
Use the chart controls on the ribbon to add labels or adjust the style.

Excel for Mac has a similar chart-insertion workflow, though the ribbon layout can differ by version and window size. Select the data, open Insert, choose the pie-chart options, and select the 3-D pie type if it is available in the menu. In Excel for the web, chart options and formatting controls can differ from the desktop app; if a particular 3-D chart or formatting control is missing, open the workbook in the desktop version of Excel.

Prepare Data That Makes Sense as a Pie

A pie chart communicates how a set of categories contributes to one whole. The values should be comparable parts of the same total, such as the share of orders by product, a department’s share of a fixed budget, or the percentage of survey responses in each answer category. A pie chart is not a good fit for unrelated measures, such as comparing temperatures in several cities, because those values do not add up to a meaningful whole.

For a clear result, use one row per category and one value per row. Check that category names are distinct enough to recognize and that the values are numeric. A pie chart can become difficult to read when there are many tiny categories. If several small categories are not important individually, you might group them as Other, but only when that grouping is appropriate for the data and does not hide a detail readers need.

Use one series: A pie chart represents one set of values. If the table contains several separate series, choose one series or use another chart type.
Use nonnegative parts: Negative values do not represent ordinary shares of a whole. Choose a chart designed for the question if decreases or losses need to be shown.
Check the total: Percentages describe each value as a share of the values included in the chart. Make sure the selected range includes the categories you intend to compare.
Keep labels short: Long category names and many slices can make labels overlap or become hard to scan.

For instance, suppose a table lists 40, 35, and 25 orders for three product lines. The total is 100, so the slices represent 40%, 35%, and 25%. If a fourth product with 10 orders is included, the total becomes 110, and the first three shares become about 36.4%, 31.8%, and 22.7%. The chart’s percentages depend on which values are included, so selecting the intended data range matters.

What the 3-D Effect Changes

The chart still represents the same underlying values as a two-dimensional pie chart. The 3-D effect adds depth and perspective to the drawing; it does not create another data dimension or make the figures more precise. In a pie chart, the angle of each slice corresponds to its share of the total. The three-dimensional rendering changes how that shape looks on screen or on a page, not the calculation behind it.

Perspective can make slices nearer the viewer appear larger or more prominent than slices toward the back. The thickness and viewing angle can also make it harder to judge slice angles accurately. As a result, a 3-D pie may look more dramatic but can be less effective for comparing similar values. A 2-D pie is usually easier to read when the goal is to compare proportions, especially when several slices are close in size.

Use a 3-D pie when the visual style is appropriate and the broad part-to-whole message is easy to understand. Avoid using the effect to imply that one category is more important than its data supports. If exact comparison matters, add clear labels or use a bar chart, where lengths are generally easier to compare than perspective-distorted slices.

Add Data Labels, Percentages, and a Legend

Labels help readers identify slices without repeatedly matching colors to a legend. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and pick a position. Available position choices depend on the chart type and Excel version. To control what the labels show, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, or right-click a label and choose Format Data Labels.

In the formatting pane, choose whether to display category names, values, percentages, or a combination. Percentages are useful when readers care about each category’s share; values are useful when the underlying counts or amounts matter. Showing both can provide context, such as 40% (40 orders), but too much text around a small pie can cause clutter. If the chart already has an understandable title and labels, a separate legend may not be necessary.

A chart title should describe what the values measure and, when useful, the time period or population. Sales by itself is vague; Sales by Product in October is more informative if that accurately describes the data. Avoid titles that claim a conclusion the chart does not establish. Also check that label formatting uses the right number style: a currency value, a whole-number count, and a percentage communicate different things.

Format Slices and Adjust the Viewing Angle

Use formatting to improve clarity, not to make slices appear to have different values. Select the chart and explore the Chart Design tab for chart styles and color choices. The Change Colors control offers coordinated palettes. Choose colors with enough contrast to distinguish adjacent categories, and do not rely on color alone if the chart will be viewed by people who may have difficulty distinguishing those colors. Labels can provide a second way to identify each slice.

To emphasize one slice, select the pie once and then select the individual slice, or right-click that slice and open its formatting options. Excel provides a point-explosion setting for separating a data point from the rest of the pie; the exact controls shown can depend on the selection and version. You can also drag a slice outward in some desktop chart interactions. Use a modest separation for a meaningful highlight. Pulling several slices apart weakens the sense that they form one whole.

To adjust the 3-D perspective in desktop Excel for Windows, right-click the chart area, choose Format Chart Area, and look in the formatting pane under Effects > 3-D Rotation. The controls can vary with chart type and Excel build. Small angle adjustments may improve the view, but rotation cannot remove the basic limitation that perspective affects perceived size. On Mac, the pane and controls may be arranged differently; look for the chart-area effects and rotation settings in the formatting interface.

Common Problems and How to Fix Them

If the chart shows unexpected categories or values, first inspect the selected range. A heading accidentally treated as a value, a total included as another category, or an extra blank row can change the chart. Select the chart and use Chart Design > Select Data to review the data range and series. For a simple pie, the source should contain one series of values associated with the category names.

Only one slice appears: Check that the value cells contain distinct numeric values and that the chart range includes all the intended rows. Text stored in place of numbers may not behave as expected.
Labels overlap: Reduce the number of categories, use shorter names, change label placement, or show fewer label fields. A legend may work better than placing long names around every slice.
The percentages seem wrong: Confirm that the selected chart range contains only the categories that should make up the whole. A total row should not normally be included as an additional slice.
The chart does not update as expected: Check whether new rows are inside the chart’s source range. If necessary, use Chart Design > Select Data to adjust it.
The 3-D chart is hard to interpret: Try a 2-D pie or a bar chart. Changing the angle may improve presentation but does not make close values easier to compare reliably.

One common misconception is that a 3-D pie chart shows a third variable because it appears to have depth. It does not: its depth is visual styling. Another is that a slice’s apparent front-to-back size is a reliable way to compare values. Perspective can affect that impression, so use the data labels or a chart better suited to precise comparisons.

When to Choose a Different Chart

A pie chart is most suitable when there are a few categories and the reader needs to understand their shares of one total. A 2-D pie is a straightforward alternative when you want the same part-to-whole view without perspective. A doughnut chart also shows category shares, with a blank center that can be useful for a short central label, although it still has the same challenge of comparing similarly sized slices.

For ranking categories or comparing values that are close together, use a bar or column chart instead. The bars’ lengths make small differences easier to compare, and category labels are often easier to accommodate. A stacked bar chart can show how several parts contribute to totals across multiple groups. If the purpose is to show change over time, a line chart or column chart is usually more appropriate than a pie chart for each time period.

For example, a pie chart can work for the share of a single month’s orders across three products. If you need to compare those shares month by month, a set of pie charts can be difficult to scan. A stacked column chart or a line chart of the underlying values may make the pattern clearer, depending on whether the question is about composition or change. Choose the chart type based on the question the reader needs answered, not simply on which chart looks more decorative.

Frequently Asked Questions

How do I make a 3-D pie chart in Excel?
Select category names and their values, then choose Insert > Insert Pie or Doughnut Chart > 3-D Pie in Excel for Microsoft 365 on Windows. Add a descriptive title and labels if they help readers understand the slices.

Can an Excel pie chart show percentages?
Yes. Select the chart and use Chart Design > Add Chart Element > Data Labels, then open the data-label options and enable percentages. The percentages are calculated from the values represented in the chart, so verify the source range first.

Can a pie chart show more than one data series?
A standard pie chart is designed to show one data series divided into categories. If you need to compare multiple series, consider a clustered or stacked bar or column chart, or another chart type suited to the comparison.

Why do my 3-D pie slices look different in size?
Perspective can make slices nearer the viewer appear more prominent than slices farther away. The underlying values have not changed, but the visual effect can make comparison less reliable. Add labels or switch to a 2-D pie or bar chart when accuracy of visual comparison is important.

Can I turn a 3-D pie chart into a 2-D pie chart?
Yes. Select the chart and use the chart-type controls on the Chart Design tab to change the chart type to a 2-D pie. The exact dialog layout may vary between Excel versions; choose the standard two-dimensional pie option rather than the 3-D type.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.