In this video we will learn how to create column charts column cards are one of the most common types
of chart a column chart displays.
Each data point as a vertical column the height of which corresponds to devalue the value scale is displayed
on the vertical axis which is usually on the left side of the chart.
You can specify any number of data series and the corresponding data point for each series.
Typically each data series is depicted in a single color so that you can identify different data cities
with different colors and patterns column charts are often used to compare discrete items and they can
depicted differences between items in a series of items across multiple cities.
There are different types of column charts the chart that you have.
You are seeing here is called plus third column chart to look at all the different types of column charts
available.
You will go to the Insert menu
and within this.
This is the symbol for column chart.
You can see all these are the options available in column chart.
This first one is the clustered column chart which is the standard column chart.
The second option is off stag column chart in which the data cities are staggered over one.
The third type is a hundred percent staggered column chart.
Data set is as dead and are expressed as percentages in the second row.
You can see the 3D versions of column chart the first one is 3D clustered column which is the same as
to the left column but just in three dimensions.
Second is 3D stat column.
Third is 3D.
Hundred percent stat column and the last one is 3D column in which multiple cities are arranged along
a third axis
to not let us discuss about this but the example of clustered column chart.
In this column chart you can see monthly sales for two product shows and banks from this chart.
It is clear that bank sales have always exceeded shirt sales.
In addition short sales have been declining over the months whereas bank sales are increasing
to not let us learn how to create this clustered column chart.
Let us first delete this chart that I have already created.
Now the easy way is we will select the whole data.
We will go to the clustered column option and insert menu and will click it and you can see that we
have at clustered third column chart drawn for us.
The problem with drawing the chart like this is in case you want to add additional column in this table
all you want to add more months in this table.
You will find difficulty in creating this chart again.
That is why will be learning how to create this chart from a blank slate.
So I will delete this chart will launch select the data and then we will go to insert will select a
column chart this is blank.
Nothing is drawn noted when you have selected this chart area you will get two additional options in
the menu.
One is design and one is format post will go to the design tab and then we will select this selected
option.
This selected option can also be accessed by right clicking on this chart area and selecting selected
option.
So now now you can see there are two parts in this data selection dialog box.
The first part is of login entries.
These this will really data it is that you want to plot so we will click on Add button if we see two
parts coming up.
One is series name.
So our first series is what shots so we'll select shorter.
And these second boxes for data series values.
So we will select all of these values and you can see in the background the sales of should are plotted
in the jar.
We can click Okay so this is one data series which is these showed data series which is plotted.
Let us add the second dataset is
this is it did as it is name then.
This is the data series values gone.
Okay.
Now you can see on the top the chart data range is getting updated on its own.
This is the data that you are selecting.
Now on the lighting side that is horizontal axis labels by default Excel selected one two three four
five which you can see in the chart also instead of one two three four five we wanted the month names
which is Jan for March April May.
So we will click on edit and we will select these five values and click on okay.
You can see that we are getting Jennifer March April now as axis labeled and click on okay and you can
see that we have the two data as it is plotted and this stat column chart.
In case you want an added column of sales of pair of shoes you can add that here and you can go to these
select data table of select opt in on this chart and you can add another seat
now in this chart there are two important information missing.
One is the chart title that it is depicting the sales of that product.
So we will add a chart title and there is a box of the agent missing which will tell us what this orange
do does it is is depicting and what this blueberry does it is depicting.
So we will add the two elements of chart modeling on this plus button and we'll take this chart a blue
box and the Legion box.
Now you can see the shot dead as it is is plotted in blue and the date as it is is plotted in Orange.
We can change the text into each our title by devils living on it during a day and bring the sales to
our title that we want for this chart.
If you want to change the location of this Legion box that is if you wanted below your chart you can
drag and drop it.
So this is how we make a clustered column chart.
If we want to make a stag column chart it is very easy.
Once we have created this chart we can just select this chart area by clicking anywhere on this chart
idea and then going to insert and then changing the chart type to start column in this chart type the
two data series one off banked and one off showed is stag one or another and you can see the total is
as one single but this chart has the added advantage of depicting the combined sales over time.
It shows the total sales have remained relatively steady over the years but the relative proportions
of the product have changed.
However the limitation of this chart is you can only compare this lower data series since it has a common
base for this audience data series which is debating panties.
You cannot really compare the change in its values because the base is constantly changing.
You get an idea that it is increasing over time but still it is not that clear.
Moreover if you have more than two data cities it becomes even more complicated.
Now let us go and change this chart.
Two hundred percent stat column chart.
Now you can see that the top is matched.
That is it is a hundred percent for each month.
So this chart is showing us the relative contribution of each product by the month.
Notice that the value axis is displaying percentage values no and not see that amount.
So this chart provides no information about the actual sales volumes.
This type of chart is a good option when you want to compare the contribution of different categories
to the total.
Now you can also create three dimensional graphs using these options usually 3D graphs and no additional
information that just showing the same result in a 3D format.
Some people use it because they find it visually appealing but in most of the business settings 3D graphs
are not really preferred.
People usually refer to the graphs although you can create 3d graphs if you want.
This is the option to create 3-D graphs.
You can always create a Do the graph and then can order to 3D another set of similar charts are known
as bar chart.
You can see these are the bar chart options available.
These are exactly similar to column charts.
Only difference is that the column on that this bar is rotated 90 degrees clockwise that is instead
of vertical but will be having horizontal bars one and one data using a bar chart.
Is that the category labeled that is the horizontal axis labeled.
Which one in the column chart can be easily did in a bar chart so you can see if I have these months
here.
If these values are longer
it can be easily made in this bar chart instead if it was in a column chart these values mail overlap
and it would be difficult to read.
You can see that these two values are getting congested and if you have even bigger labels it will get
overlapped and difficult to read.
So all the options in column chart that was that we saw are also available in budgets.
You can see this is the clustered bars.
This is the stack but and this is a hundred percent stag but these are the 3D version of it.
So all those options that we saw in the column charts are also illegal in budget.
So in this video we learned how to create a column chart and a bar chart from a data table.
We also learned how to add the missing element of chart.
We added chart title and chart login using this plus icon in direct.