1 00:00:01,540 --> 00:00:09,720 In this we do lecture we will learn about combination charts a combination chart is a single chart that 2 00:00:09,720 --> 00:00:15,030 consists of cities that use different chart types. 3 00:00:16,230 --> 00:00:18,010 That is in the same chart. 4 00:00:18,060 --> 00:00:24,170 You can use two or more types of chart to show different data cities 5 00:00:27,010 --> 00:00:33,980 so in a combination chart we have two or more types of charts in a same single chart. 6 00:00:33,980 --> 00:00:39,140 Each type of chart will be debating a different data series. 7 00:00:40,400 --> 00:00:48,830 So earlier when we drew clustered column chart with multiple data cities for each month value we were 8 00:00:48,830 --> 00:00:57,180 having two columns representing the value of each data as it is not in state of that second column. 9 00:00:57,320 --> 00:01:02,960 The value of that tagging columns will be represented by this line. 10 00:01:03,020 --> 00:01:05,050 So here we have two data series. 11 00:01:05,750 --> 00:01:15,560 And in this combined chart one data series is represented by bus and one is represented by Lane creating 12 00:01:15,560 --> 00:01:19,070 a combined chart is also very simple. 13 00:01:19,070 --> 00:01:28,580 We will select the data and go to the Insert menu and this sixth option is the inside combo chart. 14 00:01:29,240 --> 00:01:30,150 Click on it. 15 00:01:30,200 --> 00:01:37,060 This the first option head is Atlas third column plus line chart. 16 00:01:37,070 --> 00:01:38,870 This is what we had created earlier. 17 00:01:40,580 --> 00:01:48,650 So in this chart there is one vertical axis which is used for both the cities and one of these cities 18 00:01:49,010 --> 00:01:58,430 is represented by Bob's and the other is represented by light in the second table combination chart. 19 00:01:58,430 --> 00:02:01,100 We have two vertical axis. 20 00:02:01,100 --> 00:02:04,700 One is the primary axis which has a different scale. 21 00:02:04,880 --> 00:02:07,900 And there is a secondary axis which has another scale. 22 00:02:09,050 --> 00:02:16,850 So a since I had income values in the same range I used a common primary axis. 23 00:02:16,850 --> 00:02:25,520 Now I have one cities as income and the other cities as profit margin and both of these have skills 24 00:02:25,610 --> 00:02:27,500 which cannot be compared. 25 00:02:27,530 --> 00:02:37,250 I am using two different skills to the bars which represent income correspond to the primary vertical 26 00:02:37,250 --> 00:02:45,830 axis and the line chart which represent profit margin correspond to these secondary axis to draw this 27 00:02:45,830 --> 00:02:48,370 graph. 28 00:02:49,090 --> 00:03:01,070 Again selected table 12 insert and select the second option in the combination chart so the second option 29 00:03:01,070 --> 00:03:07,040 is a combination of line and bar chart with two vertical axis. 30 00:03:07,070 --> 00:03:11,370 Primary and secondary vertical axis. 31 00:03:12,050 --> 00:03:22,580 The third type of combination chart is a combination of bar graphs and area chart so the same information 32 00:03:22,700 --> 00:03:28,090 which is given by this line will be represented by an idea chart 2. 33 00:03:28,220 --> 00:03:30,170 I believe this chart. 34 00:03:30,440 --> 00:03:41,210 Select this data again and insert that third type of combination chart you can see one of these cities 35 00:03:41,270 --> 00:03:47,980 is represented by bars and data that is represented by an area chart. 36 00:03:48,080 --> 00:03:55,210 There is one last option while creating a combination jug which just to create custom charts when you 37 00:03:55,210 --> 00:03:56,920 are creating a custom chart. 38 00:03:56,990 --> 00:04:04,370 The options are not limited to using bars or lines or ADR chart you can create any combination of different 39 00:04:04,370 --> 00:04:05,420 chart. 40 00:04:05,450 --> 00:04:12,800 So for example if you want a combination of Bob chart and a pie chart even that can be done in an odd 41 00:04:12,800 --> 00:04:18,440 example we are creating a combination of bottom line and then ADR chart. 42 00:04:19,940 --> 00:04:26,510 Although this is not the preferred graph since it has too much information in it and it is not clearly 43 00:04:26,510 --> 00:04:35,660 conveying the message that it should convey just for the example purposes I'm showing you this on the 44 00:04:35,660 --> 00:04:35,990 left. 45 00:04:36,200 --> 00:04:41,720 If you look at the table I have income from Source 1 and income from those 2 and the first two columns 46 00:04:42,050 --> 00:04:45,400 and the third column is profit margin. 47 00:04:45,440 --> 00:04:54,050 I'll use a line chart to depict the profit margin and its values will be on the secondary axis for the 48 00:04:54,050 --> 00:04:55,340 first two columns. 49 00:04:55,430 --> 00:05:03,200 I'll create an ADR chart and a bar chart and its values will be seen on the primary vertical axis. 50 00:05:03,200 --> 00:05:05,510 So let us create this combination chart 51 00:05:08,970 --> 00:05:17,110 to link the data and go to the custom option optional combination just create custom combo chart and 52 00:05:17,150 --> 00:05:21,140 you can see that decrease it is selected. 53 00:05:21,500 --> 00:05:26,480 So those three cities are given here for the first cities. 54 00:05:26,480 --> 00:05:34,700 I want the bars so I'll select the cluster column Jack or the secondaries I want area chart so I like 55 00:05:34,700 --> 00:05:35,630 this idea chart. 56 00:05:36,620 --> 00:05:44,390 And for the territories I'm using a line Jack and these territories will also have a secondary axis 57 00:05:46,370 --> 00:05:47,400 to show these values. 58 00:05:47,510 --> 00:05:58,370 So we'll click on okay And here's our chart which is a combination of line area and budget since this 59 00:05:58,370 --> 00:06:00,530 is not looking very good. 60 00:06:00,530 --> 00:06:11,100 You can format the colors and you can increase the distance between the line John and these bars by 61 00:06:11,100 --> 00:06:14,980 changing the axis range. 62 00:06:15,090 --> 00:06:16,840 We have seen that in the alleged we did. 63 00:06:16,840 --> 00:06:21,390 Also I just quickly do that so that those contemplative raised 64 00:06:25,990 --> 00:06:31,080 red I'll change the color and it's transparency 65 00:06:34,940 --> 00:06:44,660 so that area and bars both can be seen together and for the line chart I'll move that line a little 66 00:06:44,660 --> 00:06:53,060 bit further from the bars by reducing the change on the primary axis so I'll select the primary axis 67 00:06:53,900 --> 00:06:58,140 and reduce the range. 68 00:06:58,670 --> 00:07:08,180 So if I change it to three hundred thousand we have smaller bars and the line is completely and clearly 69 00:07:08,180 --> 00:07:09,440 visible. 70 00:07:09,440 --> 00:07:14,810 So in this graph you can see all the three data series clearly and distinctly 71 00:07:17,600 --> 00:07:24,410 so in this way using a custom combination chart you can create any combination of two or more charts 72 00:07:25,670 --> 00:07:28,580 to display the information of two or more details it is.