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