How to create a surface chart
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
- Select data.
- Go to tab "Insert" on the ribbon.
- Press with left mouse button on the "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button.
- 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:
- Double press with left mouse button on the chart to open the settings pane.
- Press with left mouse button on the "Effects" button on the top menu.
- Press with left mouse button on "3-D Rotation" to expand settings.
- 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.
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.