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. Press with left mouse button on the "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button.
  4. Press with left mouse button on 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 press with left mouse button on the chart to open the settings pane.
  2. Press with left mouse button on the "Effects" button on the top menu.
  3. Press with left mouse button on "3-D Rotation" to expand settings.
  4. Press with left mouse button on the arrow buttons to change the x, y rotation and perspective or simply type the value you want in the corresponding fields.