In this video, we will learn how to format this simple column, chart the format in contempt 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 charts that we'll be learning
later on in the schools like pie charts, histograms, etc., you can do the same formatting and all
those charts.
Also, as I told you, this chart has several element to this chart titled 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 click on it and choose the option of format axis.
If you click on this, you can see that we get a separate set of options on the right and this right
window.
You can see in this dropdown horizontal category axis is selected because I double clicked on horizontal
axis and I 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, first is filled in line with his background and border related formatting
options, the second effect and this you can add three dimensional effects or shadows and button effect.
And the third option is size and properties.
You can change the size of this window that we have selected.
You can also take this size by dragging this corner point so you can change the height and weight of
this chart or 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 well, which is what the background and the second option down there
is for border right now.
It is automatic for both.
First of all, will add a solid line border to our 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 debate and increase the rate for just so that you can notice it.
So you can see we have a border added to our chart, you can also add a background using this Voloshin.
So if you click on solid, you can filter color in it and you can see that whole chart area has a solid
feel if you've taken the gradient.
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 great manner.
The third default option is of picture or texture.
You can select a file from your system or you can select the preset textures in your Excel software
to then a 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.
Option is Battenfeld.
If you select that, you can add pattern background to your chart area.
In business setting.
Most of the times 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
change the background or the out of your chart.
Now let us go to the dropdown once again.
We have covered it.
Now let's go to Chart Titan.
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 font or the font size of this title, you can select this text and go to the
menu and within it you can board it or you can change the font from everybody to some fancy phone,
or you can increase or decrease the font size.
And using this option, you can change the color ideas like you continue to blow 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 color using those how 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 distend, you can also do that using these options.
But even these options are not really required in most of the business scenarios.
This photo is of legend.
This is the leading box.
This will give you the options of adding background and border.
These will have a special effect if we want to act.
And this particular one, which is particularly for religion, it is asking you the leading position.
So right now, what if you want the religion to be on the right of this plot area, you can select?
Right.
So this comes on the heels of this plot area if you wanted to be on the left so you can change that
top right and so on, you can undertake this if you want that your legend can overlap with the 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 body to 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 Bownds 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 this bond, that is, you want the minimum value to start from, say, thirty
thousand.
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 use is this option of no, since we have no 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 us 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 values shown here.
Since these are sales values, this dollar here makes sense.
You can change the symbol that you want, which is being shown here.
If you are working in some other currency, you can change that currency and make sure 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 the dotted line these, it will be a dotted line.
You can change the width 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 that's how you can change the dash types.
So just in case you want to highlight your grid lines so that it is easier to read the data point,
you can change the formatting of great lines from this option.
The next option is Chris.
So this is the Blue Data series, you can format this data series.
You can change the color border of the state as it is.
So right now it is blue.
If you want it to be green, you can change the 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 city's options.
It is giving us three things to decide.
One is the reason why Texas I told you that you can have to access one of the primary vertical axis
and one of the secondary vertical axis.
The left side of the graph is usually the primary axis, since both the datasets are using the left
side of the graph to show the values.
It is primary axis, but.
If you select this again, access for this plot so you can see the screen, but this first January Greenburg
DeSales, well, 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.
This is bar.
Offshores is now overlapping.
This is part of that.
So will bring them back to the primary access.
The second option is Sirees 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 bands in May have a degree DTD overlap.
The distance between these two bars will increase.
If I increase it, they will start overlapping each other so after they will overlap each other.
You can see they are overlapping, so cities overlap is the distance between the two cities the gap
that is the gap between the conservative values of these same cities.
So, for example, this short city is the distance between April value and the value you can change
using the gap with to if you decrease the gap with the April and May values of short cities are coming
together since it is getting thicker and if you increase.
The government there will shrink down so that the distance between these two values increases.
So basically U.S. cities overlap to increase the distance between two cities, data points different
to these data points and use it to increase or decrease the distance between consecutive data points
of these same cities or in a way, change the weight of the data.
Lastly, as I told you, you can add or remove elements of the chart by SELLICK 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 in this
options.
You can select that and format it to whichever element you want to have.
You added using this plus icon.
Once you've added it, you can format it 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 little.