In this we do we learn about idiot art idea charts are very similar to line charts.
The only thing is the idea below the line has been colored.
You can look at this example that I've shown.
This data.
The first column is giving us t shirt sealed in four quarters.
This right graph is the line chart of this.
These four values the left chart is the area graph you can see that area chart is same as line chart.
Only thing is that the area below this line is colored in this chart.
Now if I want to have multiple data cities in an eight year chart so just like line chart will have
multiple lines an area blue all those lines will be colored and it will be difficult to interpret it.
Let us see how to do that.
I'll add a legend Her name is band
and this series is.
These were values as it is values.
Another one of those is a name
and these for arty value.
We're gonna dig deeper learn to let us hold her.
Okay.
So you can see now we have three cities and this table is missing the legend Boxall.
Um first of all not able to identify which color is representing which cities later the login box or
the
So
So you can see we have three cities in this single chart and most of the blue cities which is representing
these short sales in the fourth quarters.
We are not able to see it because it is hidden behind the other two cities.
If you want to look at the values of shared cities we need to increase the transparency of the parent
city and the other cities.
You know how to do it.
If you select any particular date as it is
and go to format data cities and the Solid V you can add transparency by increasing your debt.
You can see that now you can look at the showed greater cities.
Now let us increase the transparency of those two cities
and also to engage scholars so that it does not match would find
so.
So now you can see the three leaders cities and you can also understand why it is very difficult to
use this area graph since these data cities are overlapping with each other.
One solution to this is using the staggered idea chart.
So if you change the area chart type
the second option is the stack data chart you can see in this example here.
So this is basically putting the data series values one way or another.
So in quarter 1 these short sales was merely add on 470 meet next.
Twelve hundred is pulled from this 470 value and it reaches up to nearly sixteen hundred
deterred value which is for others with just 564 is stacked on top of it.
So now you can easily see all the three values and you can also see the contribution of each of these
cities to the total.
And just like bar Dart a line chart B third option in this graph also is a 100 percent stack area chart
in which the total will be set 200 percent and the contribution of each individual product will be shown
as a percentage of total.
The other options and ADR chart is a 3D area 3D tag media and 3D and represent area to select 3D a chart
you can see that each of these data series is now 3D one altitude of this fall is a line which is you
presenting the value at each data point you can see again this term data series is more or less dead.
So although this chart may look visually appealing to a lot of people since the day is often obscured
behind the other data series this chart type is not recommended for business use most of the names.