In this we do lecture we will learn about combination charts a combination chart is a single chart that
consists of cities that use different chart types.
That is in the same chart.
You can use two or more types of chart to show different data cities
so in a combination chart we have two or more types of charts in a same single chart.
Each type of chart will be debating a different data series.
So earlier when we drew clustered column chart with multiple data cities for each month value we were
having two columns representing the value of each data as it is not in state of that second column.
The value of that tagging columns will be represented by this line.
So here we have two data series.
And in this combined chart one data series is represented by bus and one is represented by Lane creating
a combined chart is also very simple.
We will select the data and go to the Insert menu and this sixth option is the inside combo chart.
Click on it.
This the first option head is Atlas third column plus line chart.
This is what we had created earlier.
So in this chart there is one vertical axis which is used for both the cities and one of these cities
is represented by Bob's and the other is represented by light in the second table combination chart.
We have two vertical axis.
One is the primary axis which has a different scale.
And there is a secondary axis which has another scale.
So a since I had income values in the same range I used a common primary axis.
Now I have one cities as income and the other cities as profit margin and both of these have skills
which cannot be compared.
I am using two different skills to the bars which represent income correspond to the primary vertical
axis and the line chart which represent profit margin correspond to these secondary axis to draw this
graph.
Again selected table 12 insert and select the second option in the combination chart so the second option
is a combination of line and bar chart with two vertical axis.
Primary and secondary vertical axis.
The third type of combination chart is a combination of bar graphs and area chart so the same information
which is given by this line will be represented by an idea chart 2.
I believe this chart.
Select this data again and insert that third type of combination chart you can see one of these cities
is represented by bars and data that is represented by an area chart.
There is one last option while creating a combination jug which just to create custom charts when you
are creating a custom chart.
The options are not limited to using bars or lines or ADR chart you can create any combination of different
chart.
So for example if you want a combination of Bob chart and a pie chart even that can be done in an odd
example we are creating a combination of bottom line and then ADR chart.
Although this is not the preferred graph since it has too much information in it and it is not clearly
conveying the message that it should convey just for the example purposes I'm showing you this on the
left.
If you look at the table I have income from Source 1 and income from those 2 and the first two columns
and the third column is profit margin.
I'll use a line chart to depict the profit margin and its values will be on the secondary axis for the
first two columns.
I'll create an ADR chart and a bar chart and its values will be seen on the primary vertical axis.
So let us create this combination chart
to link the data and go to the custom option optional combination just create custom combo chart and
you can see that decrease it is selected.
So those three cities are given here for the first cities.
I want the bars so I'll select the cluster column Jack or the secondaries I want area chart so I like
this idea chart.
And for the territories I'm using a line Jack and these territories will also have a secondary axis
to show these values.
So we'll click on okay And here's our chart which is a combination of line area and budget since this
is not looking very good.
You can format the colors and you can increase the distance between the line John and these bars by
changing the axis range.
We have seen that in the alleged we did.
Also I just quickly do that so that those contemplative raised
red I'll change the color and it's transparency
so that area and bars both can be seen together and for the line chart I'll move that line a little
bit further from the bars by reducing the change on the primary axis so I'll select the primary axis
and reduce the range.
So if I change it to three hundred thousand we have smaller bars and the line is completely and clearly
visible.
So in this graph you can see all the three data series clearly and distinctly
so in this way using a custom combination chart you can create any combination of two or more charts
to display the information of two or more details it is.