EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Charts Surface Charts in Excel
 

Surface Charts in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 24, 2023

Surface Charts in Excel

 

 

Excel Surface Charts ( Table of Contents)
  • What is a Surface Chart?
  • How to Create a Surface Chart in Excel?

What is a Surface Chart?

Surface charts are those charting tools provided by Excel that enhance Excel’s ability to be a visual analytics tool. These types of charts are common for temperature analysis. The chart works on numbers and requires at least two series for a generation. The chart allows easy visualization-based analysis as it rests on three dimensions. The crucial elements of a surface chart include representing dimension values or categories on the x-axis, representing the measure in the context on the y-axis, and representing different series in the given context on the third axis, i.e., the z-axis.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Create a Surface Chart in Excel?

For this demonstration, we are considering sales data for nine major cities in India. As we can see through the following dataset, the data for the nine cities have been given quarter-wise. We will build a surface chart visualization to analyze the sales and compare the sales figures across the cities.

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

Surface Charts in Excel 1-1

Let’s go through a step-by-step procedure to build a surface chart on the above dataset using the steps described below.

  • The entire dataset selected goes to the “Other Charts” option in the Insert menu, as shown in the below screenshot. In “Other Charts”, many chart options are available, from which we select the first symbol in the “Surface” option. This is illustrated below.

Surface Charts in Excel 1-2

  • In the following screenshot, the x-axis represents the categories or dimensions in the dataset, the y-axis represents the measure (in this case, Sales), and in this case, the z-axis is represented by quarters. Remember, the surface chart requires at least two series for its building. Notice the legend carefully. Usually, in charts, we find legends representing categories. However, here a legend represents a particular range of Sales values. This is how surface charts are distinguished from other charts because this chart necessarily represents a measure in terms of depth parameters.

Surface Charts in Excel 1-3

  • The generated chart may not necessarily be of the required size; we can expand it as required. The following screenshot shows the chart that has been expanded sufficiently to make every element visible.

Surface Charts in Excel 1-4

  • The default generated chart may not be present in the desired form, and by editing its properties, we can change it to the required form. For this, right-click on the chart and select the requisite one from various options. In this case, we cannot interpret the chart properly so we will rotate it slightly. For that, click on the “3-D Rotation” option. This is illustrated in the following screenshot. Once we do this, the “Format Chart Area” dialog box pops up, as shown in the screenshot after below one.

Surface Charts in Excel 1-5

  • In the “Format Chart Area” dialog box, we can set the values of the required variable as needed. Various options in the Format Chart Area are shown below. We can set the required axis value as needed, and the chart will rotate based on the value.

 Surface Charts in Excel 1-6

The following screenshot shows how the chart is rotated clockwise after we increased the x-axis value to 40 degrees.

Surface Charts in Excel 1-7

  • Now, we increased the value of the x-axis further, setting it to 70 degrees and slightly increasing the value for the y-axis by setting it to 20 degrees. Just observe the chart we get, as shown in the following screenshot.

Increase Value

As mentioned above, the chart must be expanded until it represents each element. We expanded the chart in the above step until we got a sufficiently big size chart. The chart is shown in the following screenshot. Observe the following chart. As we can see, different colors represent different categories.

Moreover, the data has been represented as a surface but still not, making it difficult for a stakeholder to interpret requisite insights from it. From the chart, we can infer that Q3 sales are much less than in other quarters. Ranges represented by colors assist us in understanding what range is depicted by sales maximum or minimum time.

Range Color

As we can see, the chart now looks much more insightful than it was before. We can change every aspect of the visualization until we get the one that we find suitable based on the problem. We can explore other types in the “Surface” category. For this, right-click on the chart, and select the “Change Chart Type” option. This is as illustrated in the below screenshot.

Change Chart Type

  • As shown in the screenshot below, we selected the second option, i.e., “Wireframe 3-D Surface”, as shown in the following screenshot, and the chart type changed. Here, the chart looks like that of a wireframe.

Wireframe 3-D Surface

  • When we change the surface chart type to the “Contour” type, we get the following screenshot, as shown in the following screenshot.

Contour Chart Type

  • We have the fourth option in the Surface chart, “Wireframe Contour”. We get the contour chart that looks like a wireframe when we select it. This is as illustrated in the below screenshot. Go through the following visualization.

Wireframe Contour

Things to Remember about Surface Charts in Excel

  • The surface chart proves to be handy when we want to analyze situations involving three-dimensional analyses with complexity(s). However, it is important to remember that one must apply the surface chart only after thoroughly studying the context to ensure that the chart is not mistakenly applied.
  • Amongst the various options available in the surface chart, one must select the appropriate one only after identifying the chart’s suitability based on the context. Each option offers some uniqueness, suits a, and is applicable in a particular situation.
  • It is essential to study each of the components of the surface chart. Understanding the chart is the most important thing.

Recommended Articles

This is a guide to Surface Charts in Excel. Here we discuss How to create Surface Charts in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Control Chart in Excel
  2. Comparison Chart in Excel
  3. Excel Animation Chart
  4. Bullet Chart in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Surface Charts Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Surface Charts Excel Template

EDUCBA

डाउनलोड Surface Charts Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW