In this video, we will learn how to create column chart, column cards are one of the most common types
of chart.
A column card 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 datasets and the corresponding data point for eatery's.
Typically, each day the series is depicted in a single color so that you can identify different datasets
with different colors and patterns, column charts are often used to compare discrete items, and they
can depict the differences between items in a series or items across multiple cities.
There are different types of column chart, the chart that you have, you are seeing here is called
a column chart to look at all the different types of column charts available will go to the insert menu.
And within this, this is the symbol for Columbine, but you can see all these are the options available
in column chart.
This first one is the column chart, which is the standard column chart.
The second option is of staggered column chart in which the datasets are stacked over one another.
Little type is the 100 percent stack column chart that data sets are stacked and are expressed as percentages
in the second row.
You can see the three divisions of column chart.
The first one is ridiculous, that column, which is the same as to declare the column, but just in
three dimensions.
Second, it reads that column thirty three hundred percent stack that column and the last one is three
column in which multiple cities are arranged along the third axis.
To discuss about this particular example of Lester column in this column chart, you can see monthly
sales for new product shows and banks from this chart.
It is clear that bank sales have always exceeded short sales.
In addition, short sales have been declining over the month, whereas bank sales are increasing.
To not let us learn how to create this clustered column chart, let us just delete this chart that I
have already created now.
The easy way is we will select the whole data, we will go to the left column option and insert menu
and will click it and you can see that we have a clustered 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
or you want to add more money in this table, you'll find difficulty in creating this chart again.
That is why we will be learning how to create this chart from a blank slate.
So we'll delete this chart, will not select the data, and then we will go to insert will select a
column chart.
This is blank.
Nothing is drawn near here when you have selected this Jared area.
You'll get two additional options in the menu.
One is design and one is format, but 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 you can see there are two parts in this data selection dialog box.
The first part is of religion and breathe this.
This will really dataset that you want to plot.
So we click on add button if we see two parts coming up.
One is name.
So our first series is what Schertz will select shorter and the second box is for dataset values.
So we will select all these values.
And you can see in the background the sales of shirts are plotted and each chart we can click, OK,
so this is one data series, which is this short data series which is plotted.
Let us add the second dataset is.
This is the city's name then.
This is data, these values.
OK, now you can see on the top the chart data range is getting updated on its own basis.
The data that you are selecting now on the right hand side, there 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 again from March, April, May.
So we will click on EDIT and we will select these five values and click on.
OK, you can see that we are getting danford multiple now as axis labels.
We click on OK, and you can see that we have the two datasets plotted in this stat column chart.
In case you want another column of sales of a pair of shoes, you can add that here and you can go to
the select data table of selected option of this chart and you can add analysis.
Now, in this chart, there are two important information missing.
One is the job title that it is depicting the sales of our product.
So we will add a title and there is a box of logins missing which will tell us what this orange dataset
is depicting and what this blue dataset is depicting.
So we will add the two elements of charge by clicking on this plus button and we'll take this chart
box and the login box.
Now you can see the short dataset is exploded and blue and the party that it is is plotted in orange.
We can change the text in the title by clicking on it during it and entering the sales job title that
we want for this chart.
If you want to change the location of this login box that if you want it below your chart, you can
drag and drop it.
So this is how we make a column chart, if we want to make a start column chart, it is very easy.
We have created the chart.
We can just select this chart area by clicking anywhere on this chart area and then going to insert.
And then changing the guard tape to start column.
In this tape, the two data is one of banks and one of Charlotte is stacked one over another.
And you can see the totals it as one single bar.
So 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 proportions of the
product have changed.
However, the limitation of this chart, as you can only compare this lower dataset, is since it has
a common base for this Orange Data series, which is debating bank sales, 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 datasets, it becomes even more complicated.
Now let us go and change this chart.
Type two hundred percent stat column chart.
Now you can see that the top is maxed, that is it is 100 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 now and not sales 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 three graphs and no additional
information that just showing the same result in a 3-D format.
Some people use it because they find it visually appealing, but in most of the business settings,
three graphs are not really preferred.
People usually refer to the groups, although you can create radiographs if you want.
This is the option to create radiographs.
You can always create a to the graph and then convert it to another set of similar charge, an honest
budget.
You can see these are the Batard 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.
But one advantage of using a bar chart is that the category labels, that is the horizontal axis label,
which were in the column chart, can be easily dead in a bar chart.
So you can see if I have these mantid, if these values are longer.
It can be easily read in this budget instead, if it wasn't a column chart, these values may overlap
and it will be difficult to read.
You can see that these two values are getting congested, and if you have even bigger labels, you'll
get walloped and difficult to read.
So all the options in column that we that we saw are also available in budgets.
You can see this is the last word, but this is the stack.
But and this is 100 percent stack box and these are the three day version of it.
So all those options that we saw in the column charts are also well within budget.
So in this video, we learned how to create a column chart and a bar chart from day to day.
Well, we also learned how to add the missing element of a chart.
We added to our title chart, Legen, using this plus icon in direct.