Surface Chart in Excel

Excel Surface Chart (Plot)

Surface Chart is a three-dimensional excel chart that plots the data points in three dimensions. You can see the mesh kind of surface which helps us to find the optimum combination between two kinds of data points. A typical surface chart is consists of three variable data points, let’s call them “X, Y, and Z”. From these available three variables, we can categorize them into two sets i.e. Independent and Dependent variables. Two variables will be independent variables and one being the dependent variable.

So, in such a way, surface chart shows the relationship between data points through mesh surface.

Surface-Chart-in-Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Surface Chart in Excel (wallstreetmojo.com)

Examples to Create Surface Chart (Plot) in Excel

You can download this Surface Chart Excel Template here – Surface Chart Excel Template

Example #1

Consider the below data to create your first-ever Surface Chart in excel.

Surface Chart in Excel Example 1

Follow the below steps to create an excel surface chart

  1. Open excel spreadsheet first.

  2. Copy the above table of data to one of the worksheets. And choose the data range.

    Surface Chart in Excel Example 1-1

  3. Now, in the ribbon tab, choose the “INSERT” option.

    Surface Chart in Excel Example 1-2

  4. Under the INSERT tab, you can see the “Chart” section. In this section, choose Stock, Surface, or Radar Chart in excel. Under this category of charts, choose the “3D Surface” chart.

    Surface Chart in Excel Example 1-3

  5. As soon as you click on the “3D Surface Chart,” you will see the below default Surface Chart in your worksheet.

    Surface Chart in Excel Example 1-4

  6. This isn’t the final end-user surface chart. We need to customize the chart to view this much better.

    Select the chart and press the shortcut key Ctrl + 1 to open up the FORMAT CHART AREA to the right of the excel spreadsheet (Excel 2013 Onwards).


    Surface Chart in Excel Example 1-5

  7. From that FORMAT CHART AREA, you can change the color of the mesh, horizontal, and vertical axis customization, and do many more things.

    In order to change the color of the mesh, you can do this under the DESIGN tab itself. By selecting the chart, you can see two Chart Tools tabs, i.e., “Design and Format.”


    Surface Chart in Excel Example 1-6

  8. Choose the “Design” tab and go to “Change Color” and choose the color at your convenience.

    Surface Chart in Excel Example 1-7
    As you can see, I have chosen the fourth one, and I can see the preview of my chart on the right side. Like this place, a cursor on each of the different color sets to preview the chart before finalizing the color combination.

  9. The next thing we need to do is to “Switch Row/Column.” Because at the time of insertion of the chart, excel assumes horizontal things are data series, and vertical things are categories.
    So we need to change the row/column under the Design tab.

    Surface Chart in Excel Example 1-8

As soon as you select this option, our chart will change automatically, and now it looks like the below one.

Surface Chart in Excel Example 1-9

Example #2

Now let’s look at one more example of the Surface Chart. For this, consider below data set.

Example 2

Copy the data to a worksheet.

Example 2-1

By selecting the data to choose the insert chart option.

Example 2-2

Now we can see the below chart.

Example 2-3

Now under the design tab, choose “Quick Layout” and choose “Layout 5”.

Example 2-4

Now our chart looks like this.

Example 2-5

So, like this, we can create a mesh kind of surface chart in excel.

Things to Remember

  • Surface Chart is not the most often used chart in the practical world, so you will not find so many resources to work with it.
  • Always choose a different color combination to give visual effects.

This has been a guide to the Surface Chart in Excel. Here we will learn how to create a surface plot using the excel spreadsheet along with practical examples and a downloadable template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>