In this video we will learn how to format this simple column chart.
The formatting concepts that we will be discussing in this video are universal for all the charts.
So even if we have not discussed any chart other than column chart the charge that we'll be learning
later on in this course like pie charts histogram etc. You can do the same formatting in all those charts
also as I told you this chart has several elements suggests our title horizontal axis vertical axis
and we can format each individual element so to format one particular element.
We have to select that element.
So for example if I want to format the horizontal axis labels I can just click on double click on the
horizontal axis labels and these will be selected.
If you want to format them you can greatly connect and choose the option of format access.
If you click on this you can see that we get a separate set of options on the right in this trade window.
You can see in this dropdown horizontal category axis is selected because I double clicked on horizontal
axis and they clicked on it to open this format option.
So by default this window had this horizontal axis selected.
If you want you can select a dot dot elements also from this dropdown window.
So let us select the first option which is chart area.
The next is three set of options.
Fosters fill and line which is background and border related formatting options.
The second is if it and this you can add three dimensional effects or shadows and button effects.
And the third option is size and properties.
You can change the size of this window that we have selected.
You can also change this I used by dragging this Gardner point so you can change the height and weight
of this chart.
All you can change the values here to increase or decrease the height and weight of this chart.
So this is how you adjust the size of the chart also.
Now let's move to the first option which is well in line.
And here we learn how to add border to this chart and how to add a background to this chart so you can
see the first option is filled with just what the background and the second option on the is what border.
Right now it is automatic for both first of all will add a solid line border to a chart.
When I click this the first thing I have to select is the color of the solid border that I want.
Will have dark blue.
You can change the transparency of the border the top the border.
You can increase the rate I'll increase the rate for just so that you can notice it so you can see we
have a border added to a chart.
You can also add a background.
Using this fill option.
So if you click on solid field you can fill the color in it.
You can see that full chart area has a solid V.
If you take on the gradient field you can see it has two colors one on the top which is white and one
on the bottom which is blue and the colors are changing in a gradient manner.
The third default option is of picture or texture.
You can select a file from your system or you can select the Prism textures in your Excel software.
When I selected picture texture it applied a default texture.
You can choose other textures from these options if you want a background photo you can go and select
that file if it is on your system.
The circular option is bad until you selected.
You can add pattern background to your childhood in business setting.
Most of their names all these fancy options are not used.
However if you are in a creative business and you want to use some of these you may go ahead and take
the background or the border of your job.
Now let us build our dropdown once again.
We have covered the idea area.
Now let's go to job title so again you can see that we have those three options with us.
You can add a background to this particular element.
So this small box will get a color or a background picture.
You can add a border to the small element so if you put a solid line the sales box will have a solid
border.
If you want to change the fun or the font size of this title you can select this text and go to the
whole menu and within it you can board it or you can change the font from calibrating body to some venti
fine or you can increase or decrease the font size and using this option.
You can change different color and I know it is black you engineer to blue on some other color whichever
you want.
The next option in this dropdown is horizontal axis.
Again you can add a background on a border to this.
Using these options you can change the fine Fine size or X color using those or many options and you
can notice that there is one fourth option here.
Just click on it.
There are four options in this.
All these formatting options are particularly for horizontal axis only.
So if you want to shift the point that this vertical axis is intersecting with the horizontal axis you
can do it using these options.
If you want to change the label distance you can alter do that using these options.
But even these options are not really required in most of the business scenarios.
This fourth option is of legend.
This is diligent box.
This will give you the options of adding that Ron and border these will be the special effects.
If you want to add and this particular one which is particularly for religion.
It is asking you d login position so they no more damage selected.
If you want this religion to be on the right of this plot area you can select.
Right.
So this comes on the light of this plot idea if you wanted to be on the left so you can change that
top right and so on.
You can until this if you want that your legend can overlap the deep plot area apart from that just
like any other element you can pick it and drop it.
You can drag and drop it to any particular position that you want.
The next option is plot area so you can see that plot area is this small box.
You can change the background of this small box if you want.
And you can add a separate model do it.
The next option is vertical axis
again all the other formatting options are similar.
Just the last one which is particularly for this vertical axis in this one of the most important things
that we often uses this bone's option.
Here you can see that on the vertical axis it is starting from zero and the highest value it is showing
us on one hundred thousand.
If you want to change these bones.
That is you want the minimum value to start from say 30000
and the maximum value to be ninety five thousand
so you can see that this graph looks a little bit zoomed in because you have removed the bottom 30000
part of this chart.
And only this top part which is showing the variation is not zoomed in.
And an important thing that we often uses this option of number since we have numbers here you may want
to change the way these numbers are displayed.
So for example if I have decimal values I may want to show some decimal values here.
So if I had to
you can see it has now two decimal values.
Now this is being shown as numbers if you want this to be shown as a dollar value or a currency value
you can select accordingly.
So for example if I select accounting you can see this dollar value is shown here.
Since these are sales values this dollar here makes sense.
You can change the symbol which you want which is being shown here.
If you are working in some other currency you can change that currency and it will show that currency
symbol
so the next option here is vertical axis.
Major grid lines so you can see the vertical axis that we have here is giving us these horizontal grid
lines.
You can change these grid lines.
You can have them as a dashed line.
You can change the entire state currently.
It's a continuous line.
If you select this dotted line these it will be a dotted line.
You can change the route of this line so that it becomes wider.
You can change the color of this line to black or to Orange whichever you like to see.
So this all you can change the dash types.
So just in case you want to highlight your red line so that it is easier to read the data point you
can change the formatting of grid land from this icon.
The next option is series showed.
So this is deep blue data series.
You can format this data as it is.
You can change the color border of the state as it is.
So right now it is blue.
If you wanted to be green you can change color to the color formatting is similar to what we have already
discussed.
We will look at this third option which is particularly for the series options.
It is giving us three things to decide.
One is large cities on which axis.
I told you that you can have two axis.
One is the primary vertical axis and one is the secondary vertical axis.
The left side of the graph is usually the primary axis.
Since both the data cities are using the left side of the graph to show the values it is primary axis
but if you select the secondary access for this plot so you can see that this green bar the first January
green but this is where you are not to be seen on the left axis they are to be seen on the right axis.
The problem with this is the bar the sales bar of short is now all lapping this is part of it.
So we'll bring them back to the primary axis.
The second option is cities overlap cities overlap is basically giving us the distance between these
two cities.
So for example we have the data point of May we have sales of shows and part in me if I decrease the
cities overlap the distance between these two bars will increase if I increase it they will start overlapping
each other.
So after zero they will overlap each other
you can see are overlapping.
So cities overlap is the distance between the two cities the gap that is the gap between the consecutive
values of these same cities.
So for example this showed cities the distance between April value and the may value you can change
using the gap with two if you decrease the gap with the April and May values of shared cities are coming
together since it is getting thicker and if you increase the gap it they will shrink down so that the
distance between these two values increases.
So basically use cities overlap to increase the distance between two cities.
Data points different to this data point and use gap weight to increase or decrease the distance between
consecutive data points of these same cities or innovate change the weight of the data series.
Lastly as I told you you can add or remove element of the chart by select by taking or taking the options
here whenever you add another element.
So for example if I add the Axis title you can see that the that axis title will come and thus options
you can select that and format it to whichever element you want to have you added using this plus icon
can you have added you can formatted by selecting it here.
These are all the formatting options that we usually use practice some of them out on your own and see
you in the next two.