How to Fix Excel Not Showing a 3D Pie Chart Option
Question details
The user is unable to find or insert a 3D pie chart in their spreadsheet, as only 2D options are available.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to create a 3D data visualization from a dataset while working in a spreadsheet.
- Observed behavior
- The 3D pie chart option is entirely missing from the chart menus, leaving only standard 2D chart options.
Verify whether you are currently working in the browser-based Excel Web App or the installed Excel Desktop application, as advanced feature availability differs significantly between the two versions.
Open the Workbook in the Excel Desktop Application
Switching from the web version to the desktop application restores full access to advanced charting features, including 3D pie charts.
The Excel web app is designed for lightweight editing and does not support rendering or creating 3D charts. To utilize these visualization features, you must open your file in the fully-featured desktop version of Excel.
While viewing your spreadsheet in the Excel web app, look at the top ribbon and click on 'Viewing' or 'Editing', then select 'Open in Desktop App'.
Once the desktop application opens, click and drag to highlight the dataset you want to visualize.
Navigate to the 'Insert' tab on the main ribbon, click the 'Insert Pie or Doughnut Chart' icon, and select '3D Pie' from the dropdown menu.

Use a Supported 2D Chart Instead
If you do not have access to the desktop application, you can use built-in 2D chart alternatives that are fully supported in the browser environment.
Easily Create 3D Pie Charts with WPS Office
If you don't have access to the expensive Excel desktop application, WPS Office Spreadsheet provides a robust, free desktop alternative that fully supports creating and editing 3D charts.
- 1. Open Your Spreadsheet: Launch WPS Office and open your existing spreadsheet or start a new workbook with your data.
- 2. Select the Data: Highlight the specific cells containing the categories and values for your chart.
- 3. Insert the Chart: Navigate to the 'Insert' tab on the top menu and click the 'Chart' button.
- 4. Apply the 3D Pie Format: In the Chart dialog box, choose the 'Pie' category on the left, select the '3D Pie' variant, and click 'OK' to add it to your sheet.

Frequently Asked Questions
Does the Excel Web App support any 3D charts at all?
No, the Excel Web App currently lacks the rendering engine required to create or view 3D charts. Attempting to view a document with 3D charts in the browser usually results in them being displayed as flat 2D charts or showing an error placeholder.
Will my existing 3D pie chart be deleted if I edit the file in Excel Online?
No, the 3D chart formatting is preserved in the file's metadata. While it may look like a 2D chart while you are working in the web app, the 3D formatting will be fully restored the next time you open the file in a compatible desktop application.
Are there other features missing from the Excel web application?
Yes. Beyond 3D charting, the Excel Web App does not support advanced macros (VBA), Power Pivot data models, advanced conditional formatting creation, or certain complex data validation rules. For these tasks, a desktop spreadsheet application is required.




