1 00:00:00,900 --> 00:00:08,100 In this video we will learn the importance of drawing a clean graph and how to avoid clutter in our 2 00:00:08,100 --> 00:00:10,960 graphs. 3 00:00:10,960 --> 00:00:17,850 So consider this scenario our friend Tom is head of the technical team the technical team in that company 4 00:00:17,940 --> 00:00:22,700 is providing support for technical issues that the employees face. 5 00:00:22,860 --> 00:00:30,750 So his team receives ideal later tickets or issues and those issues are solved by his team. 6 00:00:30,880 --> 00:00:37,590 A few months back some of the members of his team have left their team and duty which is suffering from 7 00:00:37,590 --> 00:00:47,790 being short staffed not don't want to show the trend of incoming delegates and the process to get over 8 00:00:47,790 --> 00:00:55,170 months to make his case that he needs additional staff and budget should be allocated to his team to 9 00:00:55,170 --> 00:00:55,890 hand what people 10 00:00:58,770 --> 00:01:05,570 so he gathers the data of ticket volume received and ticket volume processed and plotted over the twelve 11 00:01:05,590 --> 00:01:06,300 months. 12 00:01:06,320 --> 00:01:09,310 And this quick graph. 13 00:01:09,550 --> 00:01:14,370 This is a graph which I told you can be drawn in a single click. 14 00:01:14,380 --> 00:01:20,530 Take some time and identify the things that you can do to reduce clutter in this graph so that this 15 00:01:20,530 --> 00:01:23,580 graph is more clear and easy to understand. 16 00:01:28,180 --> 00:01:30,790 So here's how we should draw it. 17 00:01:30,940 --> 00:01:36,310 I tell you some points to help you reduce declare that in note charts. 18 00:01:36,820 --> 00:01:41,130 The first thing you're going to do is removing the chart border. 19 00:01:41,690 --> 00:01:47,320 Whenever we draw a chart in excel by default that is a chart border. 20 00:01:47,350 --> 00:01:55,510 I also told you how to draw a dart border but usually to keep the chart clean it is preferable that 21 00:01:55,510 --> 00:02:03,250 we do not have a dart border and blank white spaces are used to segregate jobs from the other information 22 00:02:03,250 --> 00:02:05,100 available in the PPD. 23 00:02:05,560 --> 00:02:09,540 So first thing is removing charred border. 24 00:02:09,670 --> 00:02:19,210 Second option is to remove degrade lanes since in this scenario the aim is not to highlight exact numbers. 25 00:02:19,210 --> 00:02:26,320 We can do over with good length but whenever we want to highlight the exact numbers we can use grid 26 00:02:26,320 --> 00:02:28,990 lines and data labels also. 27 00:02:29,020 --> 00:02:33,790 So in this particular scenario since we just want to highlight that there is a difference between received 28 00:02:33,850 --> 00:02:38,390 and processed ticket we do not need to use grid lanes. 29 00:02:39,040 --> 00:02:43,950 So that's why we have removed the grid length from this chart. 30 00:02:43,960 --> 00:02:51,820 Third thing we did is we removed the markers have again sent individual data point or data value is 31 00:02:51,820 --> 00:02:53,900 not important in this graph. 32 00:02:53,950 --> 00:03:00,260 We want to highlight that there is a difference only so that additional thing is also removed since 33 00:03:00,280 --> 00:03:03,640 it is not complementing the actual message that we want to convey. 34 00:03:04,180 --> 00:03:13,750 So we have removed those data markers also the fourth thing that we have done is head you can see that 35 00:03:14,050 --> 00:03:16,580 X axis labels. 36 00:03:16,690 --> 00:03:18,130 January February March. 37 00:03:18,130 --> 00:03:22,570 That is the complete name of the month head. 38 00:03:22,570 --> 00:03:27,520 We have used a sharp form of those month names. 39 00:03:27,520 --> 00:03:33,960 There are several reasons that showing the month names like this is more profitable than showing a month 40 00:03:33,970 --> 00:03:35,110 name like this. 41 00:03:35,170 --> 00:03:42,820 First of all the month name shown here are dated which is a little difficult to read and takes extra 42 00:03:42,820 --> 00:03:49,880 effort on part of audience to identify which month is represented at which point. 43 00:03:49,900 --> 00:03:55,240 Secondly if you use short funds also you can still clearly make out. 44 00:03:55,570 --> 00:03:57,920 What is this Jan representing. 45 00:03:58,090 --> 00:03:59,850 Or did this February presenting. 46 00:03:59,920 --> 00:04:03,830 So there is no loss of information that totally. 47 00:04:04,870 --> 00:04:11,590 It is definitely clutter free and you can see that it is not looking good but when I put it like this 48 00:04:12,010 --> 00:04:14,170 the graph is looking definitely better. 49 00:04:17,240 --> 00:04:22,120 The fifth point is that here we had two lines. 50 00:04:22,130 --> 00:04:28,130 One is a blue line and one is the red line and we have highlighted that blue line to present to get 51 00:04:28,130 --> 00:04:35,990 volume received and red line indicates to get volume processed although it is giving us the information 52 00:04:36,290 --> 00:04:38,490 about the two data series. 53 00:04:38,780 --> 00:04:46,930 But if we directly label lead to data cities that is the label of the data as it is is near the data 54 00:04:47,030 --> 00:04:53,840 it is plus the color used for that data series is the same as the color used for labeling it. 55 00:04:53,840 --> 00:05:01,700 It is easy for the audience to process that this data as it is is for the records received and this 56 00:05:01,700 --> 00:05:09,830 data series is for data gets processed so all the data legions at the bottom were also serving the purpose 57 00:05:09,830 --> 00:05:17,060 of identifying which data it is belong to the cities it is preferable that we put the names of the cities 58 00:05:17,270 --> 00:05:20,420 nearby and in the same color and format. 59 00:05:21,350 --> 00:05:29,090 So the point behind discussing this scenario is that whenever we draw a graph we should always try to 60 00:05:29,090 --> 00:05:33,560 reduce clutter and focus only on the message that we want to convey.