The surface chart is used to represent two dimensional data in 3D map. It looks like a topographical map. The higher values are shown as high peaks. It is like a curtain on a 3d column chart.
The colors in the chart does not represent any legend like other chart. The colors represent the group to which that surface belongs. The Surface chart is best used when X and Y axis are numerical ranges.

There are four types of surface charts.

1. 3-D Surface chart.
2. Wireframe 3-D Surface chart.
3. Countor chart.
4. Wireframe Countor chart.

3-D Surface chart
A 3D surface chart looks like a curtain dropped on 3D column charts. This chart is best used when x and y are numerical ranges. To understand it, let's go through an example.
Let's say we have this equation:
z= 2x³-3y²
Where -1<=x<=1 and -1<=x<=1
In above equation, x and y ranges from -1 to 1. Using this equation we have prepared a table in excel.
To create this table we used above equation. The third row represents the values of x and B column represents values of Y, both in range -1 to 1 with an interval of .5.
To create this table, follow these steps:

• First, manually prepare the table.

• Now in cell C4 write this formula. Copy it in other cells.

Disabling scroll lock on a Mac is just as easy—but only if you have a full-size keyboard. On an extended keyboard, hit the F14 button to turn scroll lock on and off. You may have to hit Shift + F14, depending on your settings.(If that doesn’t work, try Command + F14). However, if you’re working on a laptop or a smaller keyboard, you don’t have an F14 button.

The table is ready.
Now the data is ready, let's plot an 3D area chart.

1. Select the range B3:G8.
2. Go to Insert? Charts ? Surface Charts? 3D Surface chart. And it is done.

Interpretation:
The colors in the chart show the data that fall between a certain range. For example, in above chart, blue color represents values between -2 to -1, orange represents -1 to 0 and grey represents 0-1.

Wireframe 3-D Surface chart
This is same as the 3-D surface chart but without filled color. It looks like frame of colored wires for 3D surface chart.
It is easy to see the backside boundaries in wireframe chart. In 3D surface chart, it was hard to see the backside area from one perspective.
To plot a wireframe surface chart, follow the exact steps as followed in 3-D surface chart. In the end choose wireframe surface chart.
You will have a chart that looks like a frame of wires.
Interpretation:
The interpretation is same as 3D Surface chart. In wireframe it is easy to see relations between to points on 3 dimensional surface.
Contour Chart
Contour chart is just like watching a 3D surface chart from top. In general, it is very similar to a topographical google map.
In Contour chart, the depth is not that important. You can estimate the depth by evaluating shade and light but it will be tough. The the benefit of contour chart is that you can see areas covered by other ranges.

Follow exact same steps as above and in the end choose contour chart.
Wireframe Contour Chart
The wireframe contour chart is just the contour chart without the colored areas. We can see a web of different colored wires, making a contour chart. It is like seeing a wireframe surface chart from above.
So yeah guys, this how you can use different types of surface chart in excel to represent data visually. In practice, I haven't used these charts much, I may leave some points that you might know. Feel free to add those points in the comments section below. I will include that in the article with your name.

Related Articles:

Popular Articles:

Prototyping/wireframing tools are the best communication method between interaction designers, project manager, and website developers. It’s a key step of web or mobile app development process. While in principle, the design of prototypes must be a product of interaction designers, and the user-centered concept shall run through the whole product design progress. The professional perspective and rich user experience of interaction designer will directly influence the usability of the product.

Desktop-based Prototyping Tools

1. Axure RP (Mac & Win) ($495/user)

Axure RP is a desktop application that allows designers to create, test, and share interactive prototypes. Been called as the most comprehensive (in terms of functionality) prototyping tools, it’s an ideal desktop software for both static, low-fidelity prototypes and more sophisticated, interactive prototypes. As an extremely professional UX tool, Axure requires a steep learning curve.

2. Mockplus (Mac & Win) ($129/year)

Mockplus is an all-inclusive rapid prototyping tool supports for the mainstream platforms of PC, website, and mobile device. The packaged interactions components and creative preview method allow designers to design and preview within minutes. It is a solid prototyping app for professional UI/UX designers who want to produce high-quality prototypes but without too much longer learning curve. More powerful features including:

UI Flow Design Mode— Instant switch between Prototype and UI Flow design modes; Display the UI flow of all or some certain pages; Intelligent connections between pages which can be adjust manually; Display important markups of pages; Export UI Flow at once.

Repeater— Convert any component easily into a Repeater. Drag the border of a Repeater to create repeated elements. Your adjustments made on one component will be applied to all.

Demo Projects and Templates — Demo Projects: Well-structured demos for you to make reference. Templates: Various built-in templates help you to build your prototypes on them, easy and fast.

Sketch Import — Publish selected Sketch Artboards as a Team Project in Mockplus. Insert Sketch Artboards into a Mockplus Team Project.

Table Component— Like using the Excel, you can make any change to this new table component in a visual way. Not only can you insert, edit or delete a cell easily, but also set the styles and the text formats of one or multiple cells freely.

3. Justinmind (Mac & WIn) ($228/year)

Justinmind is a flexible prototyping tool for web and mobile app prototypes and high-fidelity website wireframes. The rich gestures in Justinmind allow designers to better build gesture interaction mobile apps. Justinmind also requires a deep learning curve, such as value expression.

4. Balsamiq (Win) ($89/user)

Balsamiq Mockups is a rapid wireframing tool that helps you work faster & smarter. It reproduces the experience of sketching on a whiteboard, but using a computer. By comparison, Balsamiq is more focus on static and low-fidelity prototypes.

5. OmniGraffle (Mac) ($199.99)

OmniGraffle is a powerful design tool, it has extensive options for objects, canvases, templates, inspectors, and stencils to help designers set out to do something well, quickly. It has won the Apple Design Award in 2002.

Some other mockup tools:

Origami — A free tool for designing modern user interfaces (Mac)

Adobe Experience Design — The first all-in-one tool for UX designers (Mac)

Heroine kombat vimeo 2. Prott — A new mobile app prototyping tool built for design teams (Mac) ($421/year)

Principle — An animated design tool for interactive prototypes (Mac) ($129/year)

So, the problem of how to complete a good prototype design that’s depending on how you choose prototyping/wireframing tools. Below are the most popular mockup & prototyping/wireframing tools& appsbased on the website, desktop, and mobile device.

Web-based Prototyping Tools

1.InVision ($25/month)

As a web-based collaborative program, InVision is powerful at clickable & interactive prototypes, real-time design collaboration & share. InVison is an ideal choice for high fidelity design which is always impressive. The nice features such as Invision + Sketch, Invision + Adobe could be a great helpful for designers who pursue the high-end product.

2. UXpin ($44.08 per user/year, starting from 4 users)

UXpin puts everything for designers in a UX design platform, also, it supports to upload file seamlessly on Sketch and Photoshop. Responsive prototypes and wireframes created by UXpin can run on different devices and resolutions. In addition, this software also provides version control and iterative function, you can easily share and preview prototypes by the intuitive and real-time collaboration.

3. Marvel ($168 per user/year)

Marvel is also a web-based prototyping tool with good real-time collaboration. You can simply import mockup images from Sketch or Photoshop to link into clickable interactive prototypes for different devices. Just simple drag and link, you can bring your idea to life without any code experience.

4. FluidUI ($99/year)

With built-in iOS, Material Design and Wireframe libraries containing over 2000 customizable widgets and icons, you can design and share a wireframe, mockup or prototype for any device or platform in minutes. FluidUI also features real-time collaboration for teams, video hangouts for user testing, on-device testing and interactive previews with chat/comments to share and iterate your designs with your team.

5. Proto.io

Proto.io is a very strong web app with many functions. Under the web-based environment, it supports rich gestures and touch style, such as slide, touch, zoom, press and other mainstream actions. With it, developers can create interactive prototypes for the iOS, Android and other mobile internet devices, and get feedback from users.

Some other web-based prototyping tools:

Pidoco — Online wireframe and UX prototyping tool ($660/year for premium)

Mockingbird — Wireframes on the fly ($40/month for 25 projects)

Mockflow — Great design tools and collaboration services for designers ($148/year)

Moqups — Mockup, wireframe & UI prototyping tool for creating hi-fi wireframes ($228/year for Pro)

Gliffy — Mock up web pages quickly & easily with wireframes ($480/year for 10 projects)

Wireframe.cc — Minimal wireframing tool ($390/year)

Framer — Design tool for code needed ($159/year)

Mobile-based Prototyping Tools

1. POP（Prototyping on Paper) (iOS & Android) ($168/year)

Joined Marvel in the end of 2016.

2. Tapcase (iOS)

TapCase lets designers create app prototypes from hand-drawn sketches and screen mockups. It’s quite fast and easy to create interactive elements by adding hotspots, linking target screens, and picking transition animations.

3. Marvelapp (iOS & Android) ($168/year)

Marvelapp is a free prototyping app for mobile app, the whole design progress completed on mobile devices. Like POP and Tapcase, easily upload the prepared sketches or screen mockups, and add inbuilt transitions & gestures to make the pen & paper ideas to live.

Some other mobile-based prototyping tools:

Mockplus app — Easily & quickly preview prototypes on mobile devices by scanning QR code or input the view code. (iOS & Android)

JustinMindPrototyper — The prototype viewer for Justinmind prototypes (iOS & Android)

Mockup Builder — Super-easy prototyping and mockups (iOS & Android)

Live Wires — To quick wireframe & prototype for iPhone and iPad app (iOS)

Appcooker — Prototyping studio for iPhone & iPad (iOS)

Any of your favorable mockup & prototyping tool you think should be included in this list? Please feel free to contact me. Hope this article be useful to you great UI/UX designers!

You may also interested in: