1 00:00:06,640 --> 00:00:07,740 Hello everyone. 2 00:00:07,780 --> 00:00:12,030 In this video I will show you how to create all the bar charts. 3 00:00:12,070 --> 00:00:18,160 These are another type of dynamic charts used to emphasize any particular percentage in our presentation 4 00:00:18,600 --> 00:00:19,370 or dashboard. 5 00:00:20,290 --> 00:00:26,230 Obviously in the other video also where percentages shown like this light colored boxes. 6 00:00:26,320 --> 00:00:28,630 So we have 45 percentage to show. 7 00:00:28,700 --> 00:00:33,310 And we have 45 a so-called colored and the others are not color. 8 00:00:33,360 --> 00:00:36,760 Today we will create cards like this. 9 00:00:36,850 --> 00:00:41,220 We're changing the percentage value with 20 percentage of failed to monitor. 10 00:00:41,850 --> 00:00:48,090 So for example if you want to show how popular a particular song is you show it like this ad that is 11 00:00:48,090 --> 00:00:50,540 already liked by 80 percent of people. 12 00:00:51,120 --> 00:01:01,200 If you change the value of this percentage you can see it a moment that now shows 20 percent or so that 13 00:01:01,680 --> 00:01:05,820 popular song is only 20 percent liked by people. 14 00:01:07,110 --> 00:01:15,060 Similarly you can use the other infographics of the Like button where 69 percent of people like this 15 00:01:15,060 --> 00:01:17,860 particular item. 16 00:01:17,870 --> 00:01:22,470 Now let us know on how to create such dynamic charts. 17 00:01:22,770 --> 00:01:26,860 Let us consider that I am collecting donations for a good cause. 18 00:01:27,030 --> 00:01:31,690 My aim is to collect a hundred thousand in this sale. 19 00:01:32,140 --> 00:01:40,020 I will keep updating the total value of donations accumulated this sale will give the percentage of 20 00:01:40,920 --> 00:01:42,920 my aim achieved. 21 00:01:42,950 --> 00:01:48,720 Now I want to represent this percentage as percentage of the piggy bank failed. 22 00:01:49,130 --> 00:01:52,130 I have already have an image of this piggy bank. 23 00:01:52,580 --> 00:02:01,410 So if I have 50000 which will be 50 percent of the target I want my piggy bank to be halfway when yellow 24 00:02:01,410 --> 00:02:02,360 or golden color. 25 00:02:03,240 --> 00:02:11,310 If you closely observe the thermometer charred you can see that it is a column chart where the length 26 00:02:11,310 --> 00:02:18,540 of the column proportion is increasing or decreasing with the change in percentage value. 27 00:02:19,050 --> 00:02:21,190 In fact that is duplicate. 28 00:02:21,240 --> 00:02:28,970 The trick is to overlay an image with hollow transparent center over the bar chart. 29 00:02:28,980 --> 00:02:31,480 This budget will really presenting the percentage value. 30 00:02:32,100 --> 00:02:42,190 So if I go back to my piggy bank First I will create a column chart I will go to insert select column 31 00:02:42,190 --> 00:02:42,610 chart 32 00:02:55,550 --> 00:03:01,320 so you can see I have created a column of 50 percent each. 33 00:03:01,330 --> 00:03:03,820 This is the only value that I want to show. 34 00:03:04,840 --> 00:03:07,180 I'll click okay and close this. 35 00:03:07,210 --> 00:03:14,410 I'll have to change these percentage values the access that we have on the vertical time from zero to 36 00:03:14,410 --> 00:03:20,760 a hundred percent for that I'll go and former Texas intellect the values 0. 37 00:03:20,820 --> 00:03:24,060 It will have a monopoly of zero and the maximum value of one 38 00:03:28,760 --> 00:03:29,110 book 39 00:03:32,000 --> 00:03:34,080 I chose these formatting options. 40 00:03:35,920 --> 00:03:37,910 If I take two donations to eighty thousand 41 00:03:40,570 --> 00:03:44,590 you can see the percentage of the data and the valuing jar. 42 00:03:44,590 --> 00:03:54,490 Also increased now I have to format this chart and to make it ready so that when I owe a lady piggy 43 00:03:54,490 --> 00:04:01,120 bank image or this it will represent the percentage of donations that I have received. 44 00:04:01,120 --> 00:04:05,600 So to do that I will first remove the extra things from this chart. 45 00:04:06,340 --> 00:04:07,470 I remove the chart title. 46 00:04:09,690 --> 00:04:19,350 Remove the login box clear detailed area clear the vertical axis and keep the grid lines for now so 47 00:04:19,350 --> 00:04:22,630 that I know or does the range. 48 00:04:22,860 --> 00:04:24,360 We have this chart ready. 49 00:04:25,140 --> 00:04:30,930 I'll bring this image to the top so that it overlays the chart. 50 00:04:33,080 --> 00:04:37,920 Now I'll try to get this position correctly. 51 00:04:41,190 --> 00:04:47,700 Important thing to note when you're setting these two images together is the zero of your bar chart 52 00:04:47,970 --> 00:04:52,740 should be the lowest point of your image and the hundred dollar bar chart should be the highest point 53 00:04:52,740 --> 00:04:53,420 of your image. 54 00:04:54,760 --> 00:05:01,270 That's why we can degrade land so that we can match the top and bottom of a bar chart with the image 55 00:05:05,250 --> 00:05:07,570 now that we have done it. 56 00:05:07,710 --> 00:05:12,820 Remove the bar chart under the image to the Daniel vertical position. 57 00:05:13,010 --> 00:05:15,230 You need to hold the shift key. 58 00:05:17,130 --> 00:05:20,410 And then move the chart. 59 00:05:20,490 --> 00:05:22,050 Your job is in the right position. 60 00:05:22,050 --> 00:05:26,150 You need to increase the width of this chart. 61 00:05:33,480 --> 00:05:46,160 Too late jarred Chile titties repeatedly at you can see that the piggy bank is now 80 percent full. 62 00:05:46,190 --> 00:05:47,760 You can change the color. 63 00:05:47,870 --> 00:05:52,400 As I said I want a golden yellow will change. 64 00:05:52,460 --> 00:05:53,390 Remove the boulder 65 00:05:56,940 --> 00:05:57,540 no water 66 00:06:01,350 --> 00:06:08,510 and no I'll remove the reclaimed remove the border of the chart also. 67 00:06:08,800 --> 00:06:19,060 You can see at 80 percent my piggy bank is 80 percent well if I change your donations two hundred percent 68 00:06:19,620 --> 00:06:23,710 two hundred thousand might be you will be a hundred percent food 69 00:06:30,290 --> 00:06:41,380 so your info graphic is ready you can use it in presentations audio dashboards that is all for more 70 00:06:41,380 --> 00:06:43,960 such videos please visit a YouTube channel. 71 00:06:43,960 --> 00:06:48,110 Start at the academy or if you want to learn Excel overall. 72 00:06:48,310 --> 00:06:50,560 Check out our course on udemy. 73 00:06:50,680 --> 00:06:51,070 Thanks.