1 00:00:00,960 --> 00:00:07,590 In this video we will learn how to create column charts column cards are one of the most common types 2 00:00:07,590 --> 00:00:11,040 of chart a column chart displays. 3 00:00:11,040 --> 00:00:19,290 Each data point as a vertical column the height of which corresponds to devalue the value scale is displayed 4 00:00:19,290 --> 00:00:24,660 on the vertical axis which is usually on the left side of the chart. 5 00:00:24,870 --> 00:00:33,480 You can specify any number of data series and the corresponding data point for each series. 6 00:00:33,720 --> 00:00:40,330 Typically each data series is depicted in a single color so that you can identify different data cities 7 00:00:40,490 --> 00:00:48,780 with different colors and patterns column charts are often used to compare discrete items and they can 8 00:00:48,780 --> 00:00:57,240 depicted differences between items in a series of items across multiple cities. 9 00:00:57,570 --> 00:01:01,230 There are different types of column charts the chart that you have. 10 00:01:01,470 --> 00:01:08,100 You are seeing here is called plus third column chart to look at all the different types of column charts 11 00:01:08,100 --> 00:01:09,040 available. 12 00:01:09,040 --> 00:01:10,770 You will go to the Insert menu 13 00:01:13,970 --> 00:01:15,170 and within this. 14 00:01:15,330 --> 00:01:17,510 This is the symbol for column chart. 15 00:01:17,610 --> 00:01:22,160 You can see all these are the options available in column chart. 16 00:01:22,230 --> 00:01:27,440 This first one is the clustered column chart which is the standard column chart. 17 00:01:27,450 --> 00:01:35,680 The second option is off stag column chart in which the data cities are staggered over one. 18 00:01:35,870 --> 00:01:40,610 The third type is a hundred percent staggered column chart. 19 00:01:40,810 --> 00:01:47,220 Data set is as dead and are expressed as percentages in the second row. 20 00:01:47,220 --> 00:01:55,230 You can see the 3D versions of column chart the first one is 3D clustered column which is the same as 21 00:01:55,230 --> 00:01:59,250 to the left column but just in three dimensions. 22 00:01:59,250 --> 00:02:01,040 Second is 3D stat column. 23 00:02:01,080 --> 00:02:02,010 Third is 3D. 24 00:02:02,040 --> 00:02:10,590 Hundred percent stat column and the last one is 3D column in which multiple cities are arranged along 25 00:02:10,590 --> 00:02:11,760 a third axis 26 00:02:15,000 --> 00:02:20,500 to not let us discuss about this but the example of clustered column chart. 27 00:02:20,850 --> 00:02:29,960 In this column chart you can see monthly sales for two product shows and banks from this chart. 28 00:02:29,970 --> 00:02:38,920 It is clear that bank sales have always exceeded shirt sales. 29 00:02:39,140 --> 00:02:45,970 In addition short sales have been declining over the months whereas bank sales are increasing 30 00:02:49,100 --> 00:02:53,800 to not let us learn how to create this clustered column chart. 31 00:02:54,050 --> 00:02:58,200 Let us first delete this chart that I have already created. 32 00:02:58,280 --> 00:03:04,220 Now the easy way is we will select the whole data. 33 00:03:04,220 --> 00:03:11,930 We will go to the clustered column option and insert menu and will click it and you can see that we 34 00:03:11,930 --> 00:03:16,030 have at clustered third column chart drawn for us. 35 00:03:16,100 --> 00:03:23,300 The problem with drawing the chart like this is in case you want to add additional column in this table 36 00:03:23,800 --> 00:03:27,240 all you want to add more months in this table. 37 00:03:27,490 --> 00:03:30,910 You will find difficulty in creating this chart again. 38 00:03:31,160 --> 00:03:35,780 That is why will be learning how to create this chart from a blank slate. 39 00:03:35,780 --> 00:03:43,710 So I will delete this chart will launch select the data and then we will go to insert will select a 40 00:03:44,090 --> 00:03:47,370 column chart this is blank. 41 00:03:47,430 --> 00:03:55,290 Nothing is drawn noted when you have selected this chart area you will get two additional options in 42 00:03:55,290 --> 00:03:56,160 the menu. 43 00:03:56,160 --> 00:04:03,960 One is design and one is format post will go to the design tab and then we will select this selected 44 00:04:03,960 --> 00:04:05,100 option. 45 00:04:05,220 --> 00:04:14,810 This selected option can also be accessed by right clicking on this chart area and selecting selected 46 00:04:14,820 --> 00:04:16,680 option. 47 00:04:16,860 --> 00:04:23,520 So now now you can see there are two parts in this data selection dialog box. 48 00:04:23,520 --> 00:04:26,630 The first part is of login entries. 49 00:04:26,760 --> 00:04:35,130 These this will really data it is that you want to plot so we will click on Add button if we see two 50 00:04:35,130 --> 00:04:36,140 parts coming up. 51 00:04:36,150 --> 00:04:37,880 One is series name. 52 00:04:37,980 --> 00:04:43,470 So our first series is what shots so we'll select shorter. 53 00:04:43,740 --> 00:04:47,990 And these second boxes for data series values. 54 00:04:48,600 --> 00:04:59,070 So we will select all of these values and you can see in the background the sales of should are plotted 55 00:04:59,400 --> 00:05:00,470 in the jar. 56 00:05:00,900 --> 00:05:08,890 We can click Okay so this is one data series which is these showed data series which is plotted. 57 00:05:08,970 --> 00:05:10,470 Let us add the second dataset is 58 00:05:14,690 --> 00:05:17,800 this is it did as it is name then. 59 00:05:19,820 --> 00:05:23,880 This is the data series values gone. 60 00:05:24,010 --> 00:05:25,700 Okay. 61 00:05:26,120 --> 00:05:34,730 Now you can see on the top the chart data range is getting updated on its own. 62 00:05:34,760 --> 00:05:37,950 This is the data that you are selecting. 63 00:05:39,010 --> 00:05:47,060 Now on the lighting side that is horizontal axis labels by default Excel selected one two three four 64 00:05:47,060 --> 00:05:53,900 five which you can see in the chart also instead of one two three four five we wanted the month names 65 00:05:54,080 --> 00:05:56,580 which is Jan for March April May. 66 00:05:57,530 --> 00:06:04,040 So we will click on edit and we will select these five values and click on okay. 67 00:06:04,250 --> 00:06:14,390 You can see that we are getting Jennifer March April now as axis labeled and click on okay and you can 68 00:06:14,390 --> 00:06:21,140 see that we have the two data as it is plotted and this stat column chart. 69 00:06:21,590 --> 00:06:32,420 In case you want an added column of sales of pair of shoes you can add that here and you can go to these 70 00:06:32,840 --> 00:06:38,560 select data table of select opt in on this chart and you can add another seat 71 00:06:42,900 --> 00:06:47,970 now in this chart there are two important information missing. 72 00:06:47,970 --> 00:06:53,750 One is the chart title that it is depicting the sales of that product. 73 00:06:54,190 --> 00:07:04,350 So we will add a chart title and there is a box of the agent missing which will tell us what this orange 74 00:07:04,590 --> 00:07:08,970 do does it is is depicting and what this blueberry does it is depicting. 75 00:07:09,270 --> 00:07:16,830 So we will add the two elements of chart modeling on this plus button and we'll take this chart a blue 76 00:07:16,830 --> 00:07:20,980 box and the Legion box. 77 00:07:21,000 --> 00:07:29,030 Now you can see the shot dead as it is is plotted in blue and the date as it is is plotted in Orange. 78 00:07:29,190 --> 00:07:38,460 We can change the text into each our title by devils living on it during a day and bring the sales to 79 00:07:38,460 --> 00:07:42,570 our title that we want for this chart. 80 00:07:42,570 --> 00:07:49,260 If you want to change the location of this Legion box that is if you wanted below your chart you can 81 00:07:49,380 --> 00:07:52,960 drag and drop it. 82 00:07:53,070 --> 00:07:55,970 So this is how we make a clustered column chart. 83 00:07:58,620 --> 00:08:02,700 If we want to make a stag column chart it is very easy. 84 00:08:02,740 --> 00:08:08,490 Once we have created this chart we can just select this chart area by clicking anywhere on this chart 85 00:08:08,490 --> 00:08:20,070 idea and then going to insert and then changing the chart type to start column in this chart type the 86 00:08:20,190 --> 00:08:27,630 two data series one off banked and one off showed is stag one or another and you can see the total is 87 00:08:27,750 --> 00:08:36,720 as one single but this chart has the added advantage of depicting the combined sales over time. 88 00:08:36,750 --> 00:08:43,950 It shows the total sales have remained relatively steady over the years but the relative proportions 89 00:08:44,100 --> 00:08:47,020 of the product have changed. 90 00:08:47,070 --> 00:08:54,810 However the limitation of this chart is you can only compare this lower data series since it has a common 91 00:08:54,810 --> 00:08:59,140 base for this audience data series which is debating panties. 92 00:08:59,280 --> 00:09:06,160 You cannot really compare the change in its values because the base is constantly changing. 93 00:09:06,300 --> 00:09:10,860 You get an idea that it is increasing over time but still it is not that clear. 94 00:09:11,670 --> 00:09:16,710 Moreover if you have more than two data cities it becomes even more complicated. 95 00:09:16,750 --> 00:09:20,110 Now let us go and change this chart. 96 00:09:20,370 --> 00:09:25,310 Two hundred percent stat column chart. 97 00:09:25,530 --> 00:09:28,440 Now you can see that the top is matched. 98 00:09:28,560 --> 00:09:31,140 That is it is a hundred percent for each month. 99 00:09:32,640 --> 00:09:39,300 So this chart is showing us the relative contribution of each product by the month. 100 00:09:39,300 --> 00:09:45,150 Notice that the value axis is displaying percentage values no and not see that amount. 101 00:09:46,500 --> 00:09:52,180 So this chart provides no information about the actual sales volumes. 102 00:09:52,350 --> 00:09:58,410 This type of chart is a good option when you want to compare the contribution of different categories 103 00:09:58,860 --> 00:09:59,540 to the total. 104 00:10:01,140 --> 00:10:09,540 Now you can also create three dimensional graphs using these options usually 3D graphs and no additional 105 00:10:09,540 --> 00:10:15,840 information that just showing the same result in a 3D format. 106 00:10:15,840 --> 00:10:22,680 Some people use it because they find it visually appealing but in most of the business settings 3D graphs 107 00:10:22,680 --> 00:10:24,600 are not really preferred. 108 00:10:24,600 --> 00:10:31,530 People usually refer to the graphs although you can create 3d graphs if you want. 109 00:10:31,530 --> 00:10:34,680 This is the option to create 3-D graphs. 110 00:10:34,680 --> 00:10:42,130 You can always create a Do the graph and then can order to 3D another set of similar charts are known 111 00:10:42,130 --> 00:10:43,350 as bar chart. 112 00:10:43,530 --> 00:10:47,700 You can see these are the bar chart options available. 113 00:10:47,700 --> 00:10:50,010 These are exactly similar to column charts. 114 00:10:50,010 --> 00:10:58,020 Only difference is that the column on that this bar is rotated 90 degrees clockwise that is instead 115 00:10:58,020 --> 00:11:05,860 of vertical but will be having horizontal bars one and one data using a bar chart. 116 00:11:05,880 --> 00:11:10,620 Is that the category labeled that is the horizontal axis labeled. 117 00:11:10,650 --> 00:11:19,910 Which one in the column chart can be easily did in a bar chart so you can see if I have these months 118 00:11:19,960 --> 00:11:20,280 here. 119 00:11:20,670 --> 00:11:22,500 If these values are longer 120 00:11:28,820 --> 00:11:36,860 it can be easily made in this bar chart instead if it was in a column chart these values mail overlap 121 00:11:37,160 --> 00:11:44,610 and it would be difficult to read. 122 00:11:44,890 --> 00:11:52,090 You can see that these two values are getting congested and if you have even bigger labels it will get 123 00:11:52,160 --> 00:11:53,940 overlapped and difficult to read. 124 00:11:55,180 --> 00:12:02,240 So all the options in column chart that was that we saw are also available in budgets. 125 00:12:02,260 --> 00:12:04,530 You can see this is the clustered bars. 126 00:12:04,720 --> 00:12:12,100 This is the stack but and this is a hundred percent stag but these are the 3D version of it. 127 00:12:12,790 --> 00:12:19,460 So all those options that we saw in the column charts are also illegal in budget. 128 00:12:19,540 --> 00:12:26,440 So in this video we learned how to create a column chart and a bar chart from a data table. 129 00:12:26,440 --> 00:12:30,970 We also learned how to add the missing element of chart. 130 00:12:31,240 --> 00:12:36,790 We added chart title and chart login using this plus icon in direct.