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