Chart & Visualization Issues

Where to Find the Surface Chart Option in Excel

Tauseeq Magsi Oct 7, 2026 869 views

Question details

The user is trying to find the Surface chart option to visualize data, as it is not immediately visible as a standalone chart icon in the main ribbon.

Where Is the Surface Chart Option in Excel?

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a data visualization using a Surface chart to show relationships between multiple variables.
Observed behavior: The Surface chart option does not appear as a separate, distinct chart icon in Excel's main chart gallery on the Insert ribbon.

Before you start

Ensure your dataset is organized with both X and Y categories, as Surface charts require at least two data series to create a 3D topographic mapping of your data.

Solution 1Recommended

Locate the Surface Chart via the Waterfall Chart Dropdown

Because Excel groups several complex chart types together, you can access the Surface chart by opening the Waterfall chart menu.

To save space on the ribbon, newer versions of Microsoft Excel group Surface charts alongside Waterfall, Funnel, Stock, and Radar charts under a single dropdown menu.

Select your data

Highlight the entire dataset you want to visualize in your worksheet, including both the row and column headers.

Navigate to the Insert tab

Click on the 'Insert' tab located in the main Excel ribbon at the top of the window.

Open the Waterfall chart dropdown

In the 'Charts' group, locate and click the icon representing Waterfall, Funnel, Stock, Surface, or Radar charts (the icon usually resembles a cascading bar chart).

Select Surface Chart

Scroll through the available chart types in the dropdown menu to locate the 'Surface' section. Click on your preferred style, such as 3-D Surface, Wireframe 3-D Surface, or Contour.

Locate the Surface Chart via the Waterfall Chart Dropdown

Alternative Method: You can also click 'Recommended Charts' on the Insert tab, navigate to the 'All Charts' tab, and select 'Surface' from the list on the left side of the dialog box.

Data Visualization in WPS Office

Easily Create Complex Charts with WPS Spreadsheets

WPS Office provides an intuitive and user-friendly interface for creating advanced data visualizations. Its clearly organized chart gallery makes it easy to find and generate the exact chart type you need without hunting through hidden menus.

1. Open your dataset: Launch WPS Spreadsheets and open your existing data workbook.
2. Highlight your data: Select the specific data range and categories you wish to visualize.
3. Access the Chart menu: Navigate to the 'Insert' tab and click on the 'Chart' button to open the comprehensive chart gallery.
4. Choose your chart: Select your desired visualization type from the clearly categorized list and click 'OK' to generate the chart.

Easily plot complex data relationships and surface charts.Seamlessly compatible with Microsoft Excel (.xlsx) file formats.Completely free to use with a lightweight, fast installation.

microsoft office alternative - wps office

Frequently Asked Questions

What type of data is best suited for a Surface chart?

Surface charts are ideal for finding optimum combinations between two sets of data, much like a topographic map. They require numerical data and work best when you have categories in both rows and columns.

Why is the Surface chart option grayed out?

The Surface chart option may be disabled if your selected data does not meet the minimum requirements, such as not having enough data points or categories to successfully plot a 3-dimensional surface.

Can I change the colors of a Surface chart in Excel?

Yes, once the Surface chart is inserted, you can click on it and use the 'Chart Design' or 'Format' tabs in the ribbon to customize the color bands, styles, and 3D rotation.

Excel & Data Problems