How to Create a 3-D Pie Chart in Excel Step by Step

To create a 3-D pie chart in Excel for Microsoft 365 on Windows, select a category column and its matching values, then choose Insert > Insert Pie or Doughnut Chart > 3-D Pie. Add a clear title and labels, and check that the perspective has not made small slices hard to read. You will need a table with one set of categories and one set of nonnegative numbers.

A 3-D pie chart shows how each category contributes to a whole, using depth and perspective for a raised appearance. That effect can suit a presentation, but it can also make slice sizes harder to compare than in a flat chart. Use it when the visual style is useful and the data has only a few meaningful categories; avoid relying on depth to communicate precise differences.

What You’ll Need

Excel for Microsoft 365 desktop on Windows. The steps use the current ribbon; Excel for Mac has a similar chart workflow, with differences noted below.
A small, tidy data table with category names in one column and one numeric value per category in the next. For example, categories might be product lines and values might be units sold.
A total that represents a meaningful whole. Pie charts work best when the values are parts of the same whole, cover the categories you want to compare, and are not negative.

Step-by-Step

Arrange and check your data. Put a descriptive heading above each column, such as Category and Units sold. Enter one category per row, with its value directly beside it. Keep the category names in the first column and the numbers in the second, with no blank rows or merged cells inside the table. Check that the values are numbers, not text that merely looks like numbers. A simple example is three rows for North, Central, and South, with a sales figure beside each. The values need not add to a particular number; Excel calculates the slices as shares of their combined total.
Select the chart data. Drag across the headings and all the category and value rows, including the headings. For example, if the headings are in A1:B1 and there are four categories in rows 2 through 5, select A1:B5. Including the headings helps Excel use them for the legend and series name. If the two columns are not adjacent, select the first range, then hold Ctrl on Windows while selecting the second range; adjacent columns are simpler and less error-prone.
Insert the 3-D pie chart. On the ribbon, select Insert > Insert Pie or Doughnut Chart > 3-D Pie. Excel inserts a chart on the current worksheet. In some window sizes, the chart choices may appear as icons or a compact menu; point to a chart type to see its name before choosing. Select the regular 3-D Pie option for a standard whole pie. Do not choose 3-D Exploded Pie unless you specifically want the slices separated.
Confirm Excel interpreted the selection correctly. The chart should show one slice for each category, and the legend should list those categories. If the slices or legend look wrong, select the chart and open Chart Design > Select Data. In the Select Data Source window, check that the chart data range includes the intended cells, the series contains the numeric values, and the category labels refer to the names. Use Switch Row/Column if Excel has treated rows as separate series instead of treating each row as a category.
Add a useful chart title. Select the chart, then use Chart Design > Add Chart Element > Chart Title > Above Chart. Click the title box and type a specific description, such as Share of Annual Units Sold. A reader should be able to understand what the whole represents without guessing. If the chart already has a title box, click it and replace the placeholder text. Avoid a title that only says “Pie Chart.”
Show labels when readers need exact values or shares. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position, such as Outside End. To choose what appears, select Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, enable the options you need, such as Category Name, Value, or Percentage, and turn off unnecessary ones. If you show percentages, confirm they are easy to distinguish from raw counts. Keep labels short enough to avoid crowding.
Adjust the 3-D view only if it improves clarity. Right-click the chart area and choose Format Chart Area. In the formatting pane, open Effects and look for the 3-D Rotation controls. Adjust the rotation in small increments and check that no slice is hidden or visually exaggerated. You can also right-click the pie itself and choose Format Data Series to access series options such as the angle of the first slice. The precise controls can vary with chart selection; if you do not see rotation controls, make sure you selected the chart area rather than a label.
Polish the chart and check it at its final size. Drag a corner handle to resize the chart without changing its proportions. Use the Chart Design tab to choose a chart style or color palette that keeps neighboring slices distinct. Remove decorative effects that compete with the data, and ensure the legend is readable. If you plan to paste the chart into a report or slide, review it at the size it will actually appear; labels that look clear while editing may overlap when the chart is reduced.

On Excel for Mac, select the data and use the Insert tab to choose a pie chart, then select 3-D Pie from the chart options. The precise placement of chart formatting controls can differ from Windows, but selecting the chart and using the chart design or formatting tabs provides the equivalent options. Excel for the web may not expose every 3-D chart or rotation control; if a chart option is missing, open the workbook in the desktop app.

Common Mistakes

Selecting multiple value columns. A pie chart represents one series of values. If the selection includes several numeric series, Excel may chart only one or produce an unexpected result. Make a separate pie chart for each meaningful whole, or choose a bar or column chart to compare multiple series.
Including totals as if they were categories. If the table lists category values and then a grand total, selecting the total row adds it as another slice. Select only the individual categories; the total should not be a slice alongside the parts that make it up.
Using too many categories. A dozen thin slices make labels difficult to read, and the 3-D perspective can hide small differences. Combine minor categories into a clearly explained “Other” group when appropriate, or use a bar chart if each category needs to remain visible.
Including negative values or treating unrelated figures as parts. A pie cannot communicate negative quantities, and unrelated measures do not form a meaningful whole. Correct the data or choose a chart type that represents the values honestly.
Assuming the closest-looking front slice is the largest. Depth and angle can distort how slices appear. Do not use the front-to-back appearance as evidence of size; add percentages or values, and consider a 2-D chart if accurate visual comparison matters most.
Overloading labels and effects. Category, value, and percentage together can create clutter, especially with long names. Use only the details readers need, and avoid excessive extrusion, bright gradients, or separated slices that distract from the whole.

Tips

Sort the source rows by value before charting if that makes the pattern easier to explain. The order of the slices follows the source data; sorting changes the display order but not the underlying values.
Use percentage labels when the question is about share, and value labels when readers need the actual quantity. If both matter, include both only when there is enough room to read them.
Use concise category names in the source table. Long labels can overlap around the outside of a pie, even when the chart itself is large.
Keep a 2-D version in mind as a comparison. A flat pie avoids some perspective distortion, while a sorted bar chart is often clearer when readers need to rank categories or compare close values.
When the data changes, a chart based on the selected cell range generally updates with edits to those cells. If you add new rows beyond the original range, check whether the chart includes them; converting the data to an Excel table before inserting a chart can make an expanding data range easier to manage.

Troubleshooting

The chart is blank or a category is missing: Check that the values are numeric and that the selected range includes both the labels and values. Look for blank cells, text entries, or values stored as text. Re-enter or convert text-formatted numbers, then check the chart’s data range through Chart Design > Select Data.
The chart shows the wrong labels or slices: Open Chart Design > Select Data and inspect the series values and category label range. If the rows and columns have been interpreted backwards, select Switch Row/Column. Make sure the header row is not accidentally included as a category.
A slice is missing or the chart looks incomplete: A value of zero has no visible slice, and a negative value cannot be represented as a normal pie slice. Check for zeros, negative entries, blank cells, or filtered-out rows, and decide whether they belong in the total. Do not change a value just to make a slice appear.
The labels overlap or sit outside the chart: Enlarge the chart, shorten category names, or change the label position through Chart Design > Add Chart Element > Data Labels. In More Data Label Options, remove label details that are not essential. If the chart still feels crowded, use a legend or switch to a bar chart.
You cannot find 3-D rotation settings: Select an empty part of the chart area, right-click, and choose Format Chart Area; then check Effects for 3-D Rotation. If you selected a label or the plot itself, the pane may show different controls. If the setting is unavailable in Excel for the web, open the file in Excel for Microsoft 365 desktop.
The chart is difficult to interpret despite formatting: Return the rotation closer to its default, reduce decorative effects, or change to a 2-D pie or bar chart. A 3-D view cannot make a large number of similar values easier to distinguish.

Frequently Asked Questions

Can I make a 3-D pie chart with more than one data series?
A pie chart is designed for one series of values, with each value represented as a slice. For two or more series, use separate charts or choose a chart type designed to compare series, such as a clustered column chart.

How do I show percentages on the slices?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Percentage. You can also select Category Name if readers need to identify each slice directly.

Can I rotate a 3-D pie chart in Excel?
Yes. Select the chart area, open Format Chart Area, and look under Effects > 3-D Rotation. Adjust the view gradually; a different angle can improve visibility, but too much perspective can mislead readers about slice sizes.

Why do my values not add up to 100%?
The displayed percentages are calculated from the values included in the chart, so their total should be about 100%, subject to rounding. If they do not, check that the chart includes the intended categories and excludes any grand-total row, duplicate entries, or unrelated values.

Can I create a 3-D pie chart in Excel for the web?
Chart features and formatting controls can differ in the browser. If you cannot find the 3-D Pie option or rotation settings, open the workbook in Excel for Microsoft 365 desktop, create or format the chart there, and save the workbook.

When should I use a 2-D pie chart instead?
Choose 2-D when the goal is to compare slice sizes accurately, especially for similar values or small categories. The 3-D effect adds perspective rather than extra information, so use it only when the visual style supports the message without obscuring the data.

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.