3D Pie Chart in Excel: Create, Format, and Improve It

To make a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column range containing category names and positive values, then choose Insert > Insert Pie or Doughnut Chart > 3-D Pie. Add labels and check that the 3-D angle does not make a small slice look more important than it is.

What a 3-D pie chart shows

A pie chart divides one whole into slices. Each slice represents a category’s share of the total, so the chart is most useful when the categories are parts of the same measure and add up to a meaningful whole. The 3-D version adds depth and perspective to the familiar circle; it does not add another data dimension or show more information than a two-dimensional pie.

For example, a shop might use a pie chart to show how a month’s sales are divided among four product lines. The slice sizes represent each product line’s share of total sales. A 3-D effect can make the chart look more dimensional, but perspective can also make slices at the front appear larger than slices at the back. That visual distortion is a key reason to use this chart type cautiously.

A pie chart is generally clearest with a small number of categories and one data series. If the purpose is to compare exact values, show changes over time, or include many categories, a pie chart is usually not the strongest choice. The sections below explain how to build one and how to decide whether it suits the data.

Prepare the worksheet data

Put category labels in one column and the values to chart in the next, with a heading at the top of each column. Keep the data in a simple rectangular range, without blank rows or subtotals mixed into the categories. In Excel, the first column can supply slice names and the second can supply slice sizes.

For a worked example, enter these labels and values in A1:B5:

Product in A1 and Sales in B1
Apples in A2 and 42 in B2
Bananas in A3 and 28 in B3
Oranges in A4 and 18 in B4
Pears in A5 and 12 in B5

The four values total 100, so their shares are 42%, 28%, 18%, and 12%. Select A1:B5 to include both the headings and all four categories. The values should describe parts of one whole, use the same unit, and be nonnegative. A zero has no visible slice; negative values do not represent a meaningful share of a whole, so correct or reconsider them before charting.

Check that each category appears only once unless repeated labels are intentionally separate parts. If the source data contains dozens of rows, summarize it first—for example, with a PivotTable or a separate summary table—rather than putting every record into the pie. A chart with too many slices is hard to read even if Excel can create it.

Create a 3-D pie chart in Excel

Select the complete category-and-value range, including its headings. In the example, select A1:B5.
On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
Under the pie chart choices, select 3-D Pie. Excel inserts the chart into the worksheet.
Click the chart title and replace it with a specific description, such as Monthly Sales by Product.
Resize or move the chart as needed, keeping enough room for its title and labels.

Excel normally uses the first column for category names and the second for values when the selected range has this layout. If the chart shows the wrong categories or values, select it and use Chart Design > Switch Row/Column to change how Excel interprets the data. For a basic pie chart, the intended result is one slice per category, not one pie per row or column.

If you do not see the 3-D Pie option, confirm that you are using the desktop version of Excel and opening the Insert Pie or Doughnut Chart menu, rather than a different chart menu. Ribbon details can vary slightly by platform and update, but the chart type is available in desktop Excel for Microsoft 365 on Windows. Excel for Mac has similar chart choices, although the ribbon arrangement and some formatting controls may differ. In Excel for the web, chart creation and formatting options can vary; use desktop Excel if you cannot find or adjust the 3-D chart type you need.

Add labels that explain the slices

A colorful pie without labels often forces readers to guess which slice belongs to which category. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select an available placement. You can also right-click a slice and choose Add Data Labels. To control what appears, right-click a label and choose Format Data Labels.

In the Format Data Labels pane, choose the information readers need. Category Name identifies a slice; Value shows the underlying amount; Percentage shows its share of the pie. For the example values, percentage labels should be 42%, 28%, 18%, and 12%, because the total is 100. If the amounts are larger or the total is not a round number, Excel calculates each percentage as a share of the series total. Displaying both the value and percentage can be useful, but too many label elements can clutter a small chart.

Use a legend when it is more important to keep the chart uncluttered, but avoid making readers repeatedly match similar colors to a distant legend. For a chart intended to stand alone in a report or presentation, category names beside the slices are often more immediately understandable. Check that labels do not overlap or become too small after resizing. If they do, reduce the number of categories, change the placement, or use a different chart type rather than shrinking text until it is difficult to read.

Adjust the angle and appearance

A 3-D pie’s viewing angle affects how the slices appear, particularly because the front edge can visually enlarge the near side. To change the order around the circle, right-click a slice and choose Format Data Series. In the Format Data Series pane, look under Series Options for Angle of first slice. Adjusting this setting rotates the slice arrangement; it does not change the underlying values.

Excel also provides 3-D formatting controls for the chart’s perspective and depth. These controls may be available by selecting the chart area and opening the formatting pane, then looking under Effects for 3-D Rotation. The exact options displayed depend on which chart element is selected. If the controls are missing, click the chart area rather than an individual data label or slice. Use small changes and inspect the result, since an extreme perspective can hide slices or exaggerate their apparent size.

For presentation, choose colors that are distinct and readable, and avoid relying on color alone where the chart needs to be accessible. A descriptive title should state what the values represent and, when relevant, the time period. Remove decorative effects that compete with the data. A 3-D chart already has visual depth; extra shadows, gradients, and strong borders can make it harder to see slice boundaries and labels.

When a 3-D pie chart is a poor choice

Three-dimensional styling is not automatically clearer or more accurate. Perspective changes how large slices look, so viewers may misjudge their relative shares. A two-dimensional pie avoids the artificial depth, though it still requires viewers to compare angles and areas. If accurate comparison matters, a bar chart usually makes differences easier to judge because bars share a common baseline.

Consider a case where four departments account for 42, 28, 18, and 12 units of a total. A pie chart can communicate that the departments form a whole. But if the main question is whether one department is only slightly ahead of another, a bar chart makes the comparison more direct. If there are many departments, a sorted bar chart can also show every category without creating a crowded circle of narrow slices.

Choose a 3-D pie only when the categories make up one whole, there are few of them, and the 3-D appearance serves the presentation.
Choose a 2-D pie when shares of a whole matter but you want to avoid perspective distortion.
Choose a bar or column chart for comparing amounts across categories.
Choose a line chart for showing a measure changing over time.

Some readers assume that “3-D” means Excel is plotting three variables. It is not: a 3-D pie still shows one series of values divided into categories. The added depth is a visual effect, not an extra axis or a second measurement. If the data genuinely has three variables, select a chart designed to represent those dimensions rather than using a 3-D pie.

Common problems and practical fixes

The chart has an unexpected slice or category. Check the selected range for a total row, blank cells, or text values mixed into the data. If you included a total row, remove it from the chart range: adding the total as another slice would count it alongside the component values and misrepresent the whole.

The percentages do not match expectations. Confirm that the chart includes only the categories that belong in the whole. Percentages are based on the values in the plotted series. If the total row or an unrelated category is included, the displayed shares will differ. Also check whether the labels show values, percentages, or both.

The labels overlap or are cut off. Make the chart larger, use fewer categories, choose another label placement, or move the legend. If the chart is going into a narrow space, a bar chart may fit better. Do not assume that adding more colors or shrinking the font will solve the underlying problem of too many slices.

The chart changes when source values are edited. A chart linked to worksheet cells normally updates when those cells change. If it does not, select the chart and check Chart Design > Select Data to confirm the data range. If you add categories outside the original range, expand the range there or place the source data in an Excel table so the chart can more readily include new rows, depending on how it was created.

Frequently Asked Questions

How do I make a 3-D pie chart in Excel?
Select category names and values, then choose Insert > Insert Pie or Doughnut Chart > 3-D Pie. Add a useful chart title and data labels, and verify that all included values belong to the same whole.

How do I show percentages on an Excel 3-D pie chart?
Select the chart and add data labels, then open Format Data Labels and enable Percentage. You can also enable Category Name or Value. Percentages are calculated from the total of the values plotted in the pie, so exclude any total row from the source range.

Can I rotate a 3-D pie chart in Excel?
Yes. Right-click a slice, select Format Data Series, and adjust Angle of first slice to rotate the arrangement. To change the viewing perspective, select the chart area and look for 3-D Rotation in the formatting pane’s Effects options.

Why does my 3-D pie chart look misleading?
The perspective can make slices toward the front appear larger than slices toward the back. Change the angle or use a 2-D pie to reduce that effect. For precise comparisons between values, a bar chart is generally easier to interpret.

Can a 3-D pie chart show negative numbers?
A pie chart is meant to show positive parts of a whole, so negative values do not have a meaningful slice interpretation. Correct the data or choose a chart type that can represent positive and negative values around a baseline.

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.