In this video we will learn how to create a sophisticated sophisticated display two or more data cities
on a surface these charts can be very interesting.
But in most of the business settings these are not used
just like an online Jack.
We have one category access that was the x axis and the corresponding values was shown on the y axis.
In a surface chart we have two category axis and a value corresponding to a combination of these categories
is plotted on a surface.
As an example I have this data of how many users are visiting my website every two hours of the day.
So for example on a Monday between 3 to 2 a.m. 494 customers are visiting my website.
Between 2 to 4 a.m. 789 customers are visiting between four to six thousand customers are visiting and
so on.
And this data is available for seven days so I have two categories.
One is these days and one is the two hour slot and these are the values of customers.
Thus I will plot on the y axis these two categories.
I'll plot on these two separate axes so the values on these two separate axes will give me a surface.
So in this graph if you see my here.
So this particular line this first line of this surface is for Monday.
That is this value zero point 4 9 4 will be this value.
This corner point then it keeps on increasing.
Two point seven eight nine.
Then do one thousand fifty eight.
To this highest point.
And then again start going down the next day which is Tuesday comes a little further and it goes up
to Sunday.
This last point is what Sunday.
And as you can see this graph has different colors over the surface.
So these colors represent the same value range.
So on this part of the surface the number of visitors are see that is on a Sunday at twelve AM.
The number of visitors that I have is similar to number of listed that I have honor Tuesday at nearly
12 p.m..
So this whole part of the service represents our same value date.
So now let us learn how to create a surplus chart.
I believe this chart
will select the data go to insert go to surface chart options
and I to take this first option
again.
If the selected axis is not as but your equipment you can always go to selected option and use these
data cities that you want.
There are other types of surface chart.
If you go to the gym duct tape you can see the second type is a wireframe chart.
So instead of a sad face you'll get a wireframe and the intersection of these.
This wireframe intersection point.
These will be your data points
the third type is a surface top you
this surface top dog also known as Condor chart is how you will see that surface when you're viewing
it from the top.
So that same three dimensional figure if you look at it from the top this is how it will appear to you.
However it does not give you the idea of where the value is large and where it is small.
It is telling you where the value is similar but not when it is large or small before tapers.
This can do a lot but in a wide frame.
So this is we draw surface chart so for a start sometimes look very appealing but they are very rarely
used and you may not use them in your professional life mainly because it is very difficult to understand
and predictive value at each point of this stuff.