1 00:00:00,900 --> 00:00:09,720 In this video, we will learn how to format this simple column, chart the format in contempt that we 2 00:00:09,720 --> 00:00:13,450 will be discussing in this video are universal for all the charts. 3 00:00:14,040 --> 00:00:19,770 So even if we have not discussed any chart other than column chart, the charts that we'll be learning 4 00:00:19,770 --> 00:00:26,910 later on in the schools like pie charts, histograms, etc., you can do the same formatting and all 5 00:00:26,910 --> 00:00:27,410 those charts. 6 00:00:27,420 --> 00:00:35,430 Also, as I told you, this chart has several element to this chart titled Horizontal Axis, Vertical 7 00:00:35,430 --> 00:00:35,870 Axis. 8 00:00:36,720 --> 00:00:39,600 And we can format each individual element. 9 00:00:40,830 --> 00:00:45,240 So to format one particular element, we have to select that element. 10 00:00:46,320 --> 00:00:52,620 So, for example, if I want to format the horizontal axis labels, I can just click on Double-Click 11 00:00:52,620 --> 00:00:56,150 on the horizontal axis labels and these will be selected. 12 00:00:56,910 --> 00:01:03,560 If you want to format them, you can click on it and choose the option of format axis. 13 00:01:04,050 --> 00:01:11,100 If you click on this, you can see that we get a separate set of options on the right and this right 14 00:01:11,100 --> 00:01:11,610 window. 15 00:01:11,820 --> 00:01:19,680 You can see in this dropdown horizontal category axis is selected because I double clicked on horizontal 16 00:01:19,680 --> 00:01:23,100 axis and I clicked on it to open this format option. 17 00:01:23,410 --> 00:01:27,810 So by default, this window had this horizontal axis selected. 18 00:01:28,770 --> 00:01:33,550 If you want, you can select a dot dot elements also from this dropdown window. 19 00:01:34,590 --> 00:01:37,800 So let us select the first option, which is chart area. 20 00:01:40,340 --> 00:01:48,740 The next is three set of options, first is filled in line with his background and border related formatting 21 00:01:48,740 --> 00:01:56,030 options, the second effect and this you can add three dimensional effects or shadows and button effect. 22 00:01:57,120 --> 00:02:00,020 And the third option is size and properties. 23 00:02:00,020 --> 00:02:03,940 You can change the size of this window that we have selected. 24 00:02:04,820 --> 00:02:12,500 You can also take this size by dragging this corner point so you can change the height and weight of 25 00:02:12,500 --> 00:02:18,860 this chart or you can change the values here to increase or decrease the height and weight of this chart. 26 00:02:20,390 --> 00:02:23,760 So this is how you adjust the size of the chart also. 27 00:02:25,760 --> 00:02:28,730 Now, let's move to the first option, which is well in line. 28 00:02:29,630 --> 00:02:36,500 And here we learn how to add border to this chart and how to add a background to this chart. 29 00:02:38,120 --> 00:02:44,180 So you can see the first option is well, which is what the background and the second option down there 30 00:02:44,330 --> 00:02:46,610 is for border right now. 31 00:02:46,610 --> 00:02:49,400 It is automatic for both. 32 00:02:49,620 --> 00:02:53,120 First of all, will add a solid line border to our chart. 33 00:02:54,830 --> 00:03:01,340 When I click this, the first thing I have to select is the color of the solid border that I want will 34 00:03:01,340 --> 00:03:02,130 have dark blue. 35 00:03:04,430 --> 00:03:07,640 You can change the transparency of the border, the top, the border. 36 00:03:07,650 --> 00:03:12,440 You can increase debate and increase the rate for just so that you can notice it. 37 00:03:14,710 --> 00:03:22,810 So you can see we have a border added to our chart, you can also add a background using this Voloshin. 38 00:03:23,740 --> 00:03:33,250 So if you click on solid, you can filter color in it and you can see that whole chart area has a solid 39 00:03:33,250 --> 00:03:36,160 feel if you've taken the gradient. 40 00:03:38,760 --> 00:03:44,640 You can see it has two colors, one on the top, which is white and one on the bottom, which is blue, 41 00:03:45,060 --> 00:03:48,500 and the colors are changing in a great manner. 42 00:03:50,100 --> 00:03:53,470 The third default option is of picture or texture. 43 00:03:54,240 --> 00:04:02,370 You can select a file from your system or you can select the preset textures in your Excel software 44 00:04:03,360 --> 00:04:05,070 to then a selected picture texture. 45 00:04:05,310 --> 00:04:07,190 It applied a default texture. 46 00:04:07,830 --> 00:04:10,610 You can choose other textures from these options. 47 00:04:11,370 --> 00:04:16,350 If you want a background photo, you can go and select that file. 48 00:04:16,540 --> 00:04:17,640 If it is on your system. 49 00:04:18,870 --> 00:04:19,860 Option is Battenfeld. 50 00:04:20,110 --> 00:04:25,050 If you select that, you can add pattern background to your chart area. 51 00:04:26,310 --> 00:04:27,320 In business setting. 52 00:04:27,660 --> 00:04:31,650 Most of the times all these fancy options are not used. 53 00:04:32,280 --> 00:04:36,930 However, if you are in a creative business and you want to use some of these, you may go ahead and 54 00:04:36,930 --> 00:04:39,840 change the background or the out of your chart. 55 00:04:41,250 --> 00:04:43,440 Now let us go to the dropdown once again. 56 00:04:43,860 --> 00:04:44,780 We have covered it. 57 00:04:45,630 --> 00:04:47,180 Now let's go to Chart Titan. 58 00:04:49,140 --> 00:04:52,560 So again, you can see that we have those three options with us. 59 00:04:53,430 --> 00:04:56,990 You can add a background to this particular element. 60 00:04:57,330 --> 00:05:02,940 So this small box will get a color or a background picture. 61 00:05:03,780 --> 00:05:06,050 You can add a border to the small element. 62 00:05:06,780 --> 00:05:12,090 So if you put a solid line, the sales box will have a solid border. 63 00:05:14,490 --> 00:05:23,550 If you want to change the font or the font size of this title, you can select this text and go to the 64 00:05:23,790 --> 00:05:35,520 menu and within it you can board it or you can change the font from everybody to some fancy phone, 65 00:05:35,790 --> 00:05:38,670 or you can increase or decrease the font size. 66 00:05:39,120 --> 00:05:46,710 And using this option, you can change the color ideas like you continue to blow on some other color, 67 00:05:46,860 --> 00:05:47,580 whichever you want. 68 00:05:48,390 --> 00:05:52,560 The next option in this dropdown is horizontal axis. 69 00:05:53,490 --> 00:05:57,210 Again, you can add a background on a border to this. 70 00:05:57,210 --> 00:06:05,550 Using these options, you can change the fine, fine size or color using those how many options? 71 00:06:05,850 --> 00:06:08,750 And you can notice that there is one fourth option here. 72 00:06:09,120 --> 00:06:09,940 Just click on it. 73 00:06:12,030 --> 00:06:13,380 There are four options in this. 74 00:06:13,830 --> 00:06:18,930 All these formatting options are particularly for horizontal axis only. 75 00:06:20,790 --> 00:06:27,180 So if you want to shift the point that this vertical axis is intersecting with the horizontal axis, 76 00:06:27,300 --> 00:06:29,340 you can do it using these options. 77 00:06:30,000 --> 00:06:34,590 If you want to change the label distend, you can also do that using these options. 78 00:06:35,070 --> 00:06:39,650 But even these options are not really required in most of the business scenarios. 79 00:06:44,150 --> 00:06:46,370 This photo is of legend. 80 00:06:48,730 --> 00:06:49,870 This is the leading box. 81 00:06:52,470 --> 00:06:55,960 This will give you the options of adding background and border. 82 00:06:56,970 --> 00:06:59,690 These will have a special effect if we want to act. 83 00:07:02,190 --> 00:07:08,930 And this particular one, which is particularly for religion, it is asking you the leading position. 84 00:07:08,940 --> 00:07:15,710 So right now, what if you want the religion to be on the right of this plot area, you can select? 85 00:07:15,720 --> 00:07:16,150 Right. 86 00:07:16,650 --> 00:07:23,220 So this comes on the heels of this plot area if you wanted to be on the left so you can change that 87 00:07:24,040 --> 00:07:34,230 top right and so on, you can undertake this if you want that your legend can overlap with the plot 88 00:07:34,230 --> 00:07:34,560 area. 89 00:07:34,890 --> 00:07:40,610 Apart from that, just like any other element, you can pick it and drop it. 90 00:07:43,080 --> 00:07:46,590 You can drag and drop it to any particular position that you want. 91 00:07:50,250 --> 00:07:59,250 The next option is plot area, so you can see that plot area is this small box, you can change the 92 00:07:59,280 --> 00:08:01,800 background of this small box if you want. 93 00:08:05,820 --> 00:08:12,000 And you can add a separate body to it, the next option is vertical axis. 94 00:08:14,690 --> 00:08:19,400 Again, all the other formatting options are similar, just the last one, which is particularly for 95 00:08:19,400 --> 00:08:27,290 this vertical axis in this one of the most important things that we often uses, this Bownds option 96 00:08:28,430 --> 00:08:28,790 here. 97 00:08:28,850 --> 00:08:35,300 You can see that on the vertical axis, it is starting from zero and the highest value it is showing 98 00:08:35,300 --> 00:08:37,010 us on one hundred thousand. 99 00:08:38,120 --> 00:08:45,620 If you want to change this bond, that is, you want the minimum value to start from, say, thirty 100 00:08:45,890 --> 00:08:46,250 thousand. 101 00:08:49,860 --> 00:08:52,710 And the maximum value to be ninety five thousand. 102 00:08:57,930 --> 00:09:06,120 So you can see that this graph looks a little bit zoomed in because you have removed the bottom 30000 103 00:09:06,120 --> 00:09:12,030 part of this chart and only this top part, which is showing the variation is not zoomed in. 104 00:09:15,220 --> 00:09:23,120 And an important thing that we often use is this option of no, since we have no here, you may want 105 00:09:23,120 --> 00:09:25,710 to change the way these numbers are displayed. 106 00:09:26,270 --> 00:09:32,340 So, for example, if I have decimal values, I may want to show some decimal values here. 107 00:09:33,410 --> 00:09:35,060 So if I had to. 108 00:09:38,310 --> 00:09:40,890 You can see it has now two decimal values. 109 00:09:42,090 --> 00:09:50,760 Now, this is being shown us numbers, if you want this to be shown as a dollar value or a currency 110 00:09:50,760 --> 00:09:52,920 value, you can select accordingly. 111 00:09:52,950 --> 00:09:58,400 So, for example, if I select accounting, you can see this dollar values shown here. 112 00:09:58,650 --> 00:10:02,340 Since these are sales values, this dollar here makes sense. 113 00:10:03,480 --> 00:10:07,080 You can change the symbol that you want, which is being shown here. 114 00:10:07,140 --> 00:10:13,080 If you are working in some other currency, you can change that currency and make sure that currency 115 00:10:13,080 --> 00:10:13,410 symbol. 116 00:10:16,800 --> 00:10:25,440 So the next option here is vertical axis, major grid lines, so you can see the vertical axis that 117 00:10:25,440 --> 00:10:29,380 we have here is giving us these horizontal grid lines. 118 00:10:30,960 --> 00:10:32,780 You can change these grid lines. 119 00:10:33,030 --> 00:10:35,190 You can have them as a dashed line. 120 00:10:35,520 --> 00:10:37,030 You can change the entire state. 121 00:10:37,270 --> 00:10:38,820 Currently, it's a continuous line. 122 00:10:39,060 --> 00:10:44,020 If you select the dotted line these, it will be a dotted line. 123 00:10:45,690 --> 00:10:51,190 You can change the width of this line so that it becomes wider. 124 00:10:52,140 --> 00:10:58,420 You can change the color of this line to black or to orange, whichever you like to see. 125 00:10:59,460 --> 00:11:02,930 So that's how you can change the dash types. 126 00:11:04,770 --> 00:11:10,290 So just in case you want to highlight your grid lines so that it is easier to read the data point, 127 00:11:10,800 --> 00:11:14,580 you can change the formatting of great lines from this option. 128 00:11:16,620 --> 00:11:19,530 The next option is Chris. 129 00:11:20,760 --> 00:11:27,100 So this is the Blue Data series, you can format this data series. 130 00:11:27,570 --> 00:11:30,490 You can change the color border of the state as it is. 131 00:11:31,230 --> 00:11:32,440 So right now it is blue. 132 00:11:32,460 --> 00:11:36,780 If you want it to be green, you can change the color to the color. 133 00:11:36,780 --> 00:11:39,270 Formatting is similar to what we have already discussed. 134 00:11:39,780 --> 00:11:46,160 We will look at this third option, which is particularly for the city's options. 135 00:11:46,920 --> 00:11:49,830 It is giving us three things to decide. 136 00:11:50,160 --> 00:11:57,570 One is the reason why Texas I told you that you can have to access one of the primary vertical axis 137 00:11:57,570 --> 00:11:59,280 and one of the secondary vertical axis. 138 00:12:00,150 --> 00:12:08,070 The left side of the graph is usually the primary axis, since both the datasets are using the left 139 00:12:08,070 --> 00:12:10,730 side of the graph to show the values. 140 00:12:11,280 --> 00:12:12,990 It is primary axis, but. 141 00:12:15,450 --> 00:12:21,580 If you select this again, access for this plot so you can see the screen, but this first January Greenburg 142 00:12:21,930 --> 00:12:25,200 DeSales, well, you are not to be seen on the left axis. 143 00:12:25,540 --> 00:12:27,180 They are to be seen on the right axis. 144 00:12:28,080 --> 00:12:30,210 The problem with this is the bar. 145 00:12:30,780 --> 00:12:31,590 This is bar. 146 00:12:31,590 --> 00:12:34,190 Offshores is now overlapping. 147 00:12:34,200 --> 00:12:35,720 This is part of that. 148 00:12:37,170 --> 00:12:40,710 So will bring them back to the primary access. 149 00:12:42,510 --> 00:12:44,460 The second option is Sirees overlap. 150 00:12:45,360 --> 00:12:50,530 Cities overlap is basically giving us the distance between these two cities. 151 00:12:51,240 --> 00:12:54,150 So, for example, we have the data point of May. 152 00:12:54,780 --> 00:13:00,060 We have sales of shows and bands in May have a degree DTD overlap. 153 00:13:00,630 --> 00:13:03,150 The distance between these two bars will increase. 154 00:13:04,260 --> 00:13:11,550 If I increase it, they will start overlapping each other so after they will overlap each other. 155 00:13:15,110 --> 00:13:23,320 You can see they are overlapping, so cities overlap is the distance between the two cities the gap 156 00:13:23,320 --> 00:13:28,110 that is the gap between the conservative values of these same cities. 157 00:13:28,880 --> 00:13:36,170 So, for example, this short city is the distance between April value and the value you can change 158 00:13:36,170 --> 00:13:44,900 using the gap with to if you decrease the gap with the April and May values of short cities are coming 159 00:13:44,900 --> 00:13:51,860 together since it is getting thicker and if you increase. 160 00:13:53,910 --> 00:14:02,280 The government there will shrink down so that the distance between these two values increases. 161 00:14:02,670 --> 00:14:10,310 So basically U.S. cities overlap to increase the distance between two cities, data points different 162 00:14:10,310 --> 00:14:19,590 to these data points and use it to increase or decrease the distance between consecutive data points 163 00:14:19,590 --> 00:14:24,510 of these same cities or in a way, change the weight of the data. 164 00:14:25,050 --> 00:14:33,090 Lastly, as I told you, you can add or remove elements of the chart by SELLICK by taking or taking 165 00:14:33,090 --> 00:14:36,570 the options here whenever you add another element. 166 00:14:36,840 --> 00:14:47,000 So, for example, if I add the Axis title, you can see that the that axis title will come in this 167 00:14:47,250 --> 00:14:47,900 options. 168 00:14:48,900 --> 00:14:54,420 You can select that and format it to whichever element you want to have. 169 00:14:54,750 --> 00:14:57,210 You added using this plus icon. 170 00:14:57,720 --> 00:15:01,330 Once you've added it, you can format it by selecting it here. 171 00:15:03,210 --> 00:15:07,200 These are all the formatting options that we usually use. 172 00:15:08,700 --> 00:15:12,780 Practice some of them out on your own and see you in the next little.