Author: Oscar Cronquist Article last updated on September 26, 2018

The surface chart allows you to graph multiple data series in a 3D chart, color-coded to make the chart easier to read, however, as you perhaps already have discovered, data series may obscure each other depending on rotation and perspective.

How to build

  1. Select data.
  2. Go to tab "Insert" on the ribbon.
  3. Click the "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button.
  4. Click the "Surface chart" button.

Rotate chart

It is possible to rotate the chart if one or more data points are hidden. Here is how:

  1. Double click on the chart to open the settings pane.
  2. Click the "Effects" button on the top menu.
  3. Click "3-D Rotation" to expand settings.
  4. Click the arrow buttons to change the x, y rotation and perspective or simply type the value you want in the corresponding fields.