Home ยป Charts

Wireframe 3D Surface Chart in Excel – Insert, Working, Format

In the earlier blog, we learned the usage of the 3D Surface Chart in Excel. Wireframe 3D Surface Chart in Excel is an extension of 3D Surface Chart and the working of both of these charts is almost similar. Let us see how ๐Ÿ˜€

What is Wireframe 3D Surface Chart ?

A Wireframe means a network of lines called wires are joined to form a frame. Since this is a 3D Surface Chart, the wireframe is spread across the three axes i.e X-axis, Y-axis, and Z-axis. Each of these axes represents:-

  • X Axis – It represents the categories on the chart.
  • Y Axis – It represents the sub categories on the chart.
  • Z Axis – It represents the scale for visualizing the data points.
axis in a wireframe 3D surface chart

We need at least two data series ( each on the X and Y axis ) to be represented on this chart type. This is so because a line ( wire ) needs at least two points to be plotted to join.

Inserting a Wireframe 3D Surface Chart in Excel

Let us say we have had sales of a bakery of its cakes for a few years. The bakery owner wants to analyze these sales by using some relatable chart type. Let us make him a Wireframe 3D Surface Chart. Below is the data for sales.

inserting a 3D wireframe chart in excel raw data

As you can see there are seven columns representing years and six rows representing cakes. To insert the chart simply:-

  • Select the range of cells A1:H7
  • Go to the Insert tab on the ribbon. Click on the Recommended Charts button.
  • Open the All Charts tab in the Insert Chart Dialog Box.
  • Select the Surface Chart and choose the Wireframe 3D Surface Chart
inserting a 3D wireframe chart in excel step 2

Consequently, this will insert the chart with default formatting.

infographics Wireframe 3D Surface Chart in Excel

Adding the Hidden Values of the Axis

The chart inserted in the above section is as follows:-

inserting a 3D wireframe chart in excel result

As you can see, all six cakes are not there on the axis, although they have been plotted successfully on the chart. This happens because of the compact space on the chart. To undo this:-

  • Select the Chart and Go to the Format tab on the ribbon
  • Choose the Depth Axis (Y axis) in the Current Selection Group and press ctrl+1.
  • This opens the Format Axis Pane.
  • Go to Labels and Specify the Interval unit as 1.
adding the hidden axis labels on the chart in excel step 2

Formatting Wireframe 3D Surface Chart

Refer to the previous article to format the Wires of the above chart. All you need to change is the border color of these wires and not the fill color since it is automatic. We would now learn to format the walls of this chart. To do so:-

  • Select the Chart and go to Format Tab on the ribbon.
  • Choose Walls in the Current Selection group.
formatting the walls of a chart in excel
  • This opens the Format Walls pane at the right of spreadsheet.
  • Choose the Solid Fill Color for both of the side walls.

Similarly, you can format the base of this chart by selecting Floor in the Current Selection Group. This is how the chart looks after formatting the wireframe, walls, and floor.

formatting the walls floor and wires of a Wireframe 3D surface chart in excel

Filtering a Chart in Excel

As you can see that this chart type might be intimidating to read at first especially when you are new to it. Applying filters to the chart lets us visualize a part of the source data. To filter a chart simply:-

  • Click on the chart
  • Select the third funnel shaped button at the top right corner of the chart.
filtering a chart in excel

Consequently, you can now mark the series and categories you want in the chart and hit on apply button. Here we will take the sales data of 2021 and 2022 only and unmark the rest of the categories. The results are as follows:-

filtering the chart in excel

We have switched the rows and columns as you can see above. To switch the rows and columns simply select the chart and go to the Chart Design tab and hit on Switch Rows and Columns Button.

switch rows and columns of a chart in excel

This brings us to the end of the blog.

Leave a Comment