1
00:00:00,590 --> 00:00:10,550
Next, we want to create jobs for our expense, vital for advertisement and payroll category, so we

2
00:00:10,550 --> 00:00:18,530
have set a target of 300000 for advertisement budget and two hundred and seventy thousand for payroll

3
00:00:18,530 --> 00:00:19,130
expense.

4
00:00:20,330 --> 00:00:28,070
And we are also tracking the way to the year to date value of our advertisement and payroll expense.

5
00:00:29,950 --> 00:00:38,050
So to communicate this data, we can use the bar chart where our target will be the upper limit of our

6
00:00:38,080 --> 00:00:45,100
expenses, advertisement and payroll expenses and the amount which we have already spent.

7
00:00:46,800 --> 00:00:49,710
Will be highlighted by some other color.

8
00:00:51,220 --> 00:00:58,450
So here we will first select this data and go to insert and click on this Bartter.

9
00:01:02,780 --> 00:01:04,310
Now, this is the default.

10
00:01:05,520 --> 00:01:14,730
Generated by Excel, there is one major problem with this chart here, Excel has kept both of the target

11
00:01:14,730 --> 00:01:15,770
side by side.

12
00:01:16,320 --> 00:01:22,620
So, for example, this one is the 300000 value, which is the target for advertisement.

13
00:01:23,130 --> 00:01:27,320
And this one is the column for Target for payroll.

14
00:01:28,200 --> 00:01:29,900
But we want something different.

15
00:01:30,330 --> 00:01:31,950
We want to target value.

16
00:01:32,620 --> 00:01:34,960
Just soon to the way to devalue.

17
00:01:35,820 --> 00:01:41,550
So in this graph right now, weighted values are just too weighted.

18
00:01:41,610 --> 00:01:47,460
Values on target value of payroll is adjacent to the target value of advertisement.

19
00:01:49,370 --> 00:01:55,190
So to correct this thing, click on this which row and column button.

20
00:01:56,540 --> 00:01:59,270
Here you can see that once you switch it.

21
00:02:01,750 --> 00:02:04,360
It will switch the two columns.

22
00:02:06,430 --> 00:02:09,940
So now we have two categories, advertisement and payroll.

23
00:02:10,910 --> 00:02:18,260
We have a target budget in the form of blue column, and we have divided values in the form of Orange

24
00:02:18,260 --> 00:02:18,650
column.

25
00:02:21,300 --> 00:02:29,860
Now, if you notice in the dashboard, we have overlap these two columns because the span will always

26
00:02:29,860 --> 00:02:32,310
be less than the budget we have allocated.

27
00:02:33,070 --> 00:02:39,140
So it is better to overlap this expense in the front of the budget of that category.

28
00:02:40,090 --> 00:02:41,610
Now, how to do that?

29
00:02:42,460 --> 00:02:45,190
To do that, just select any column.

30
00:02:47,440 --> 00:02:54,550
Go to this series Options, and here you will see series or leape option.

31
00:02:56,610 --> 00:03:06,630
Now, if you increase this series or Leape option, you will see that your columns will start to overlap

32
00:03:06,630 --> 00:03:07,560
on each other.

33
00:03:09,080 --> 00:03:14,180
Now increase a two hundred percent to make a complete overlap.

34
00:03:16,560 --> 00:03:22,200
Oh, you can see that this is the total target and these are the vital values.

35
00:03:24,990 --> 00:03:33,210
We can also at the table, so, for example, if I go to here and click on the table, I can see the

36
00:03:33,210 --> 00:03:36,210
data labels for the target column.

37
00:03:36,810 --> 00:03:44,850
Now, it makes more sense to track how much of the target we have already achieved, for example, here.

38
00:03:45,950 --> 00:03:52,250
We have another column which is saying that we have achieved 70 percent of target in advertisement budget

39
00:03:52,250 --> 00:03:55,620
and 61 percent of target in payroll budget.

40
00:03:56,060 --> 00:04:00,320
Now it's better to display this information over this column.

41
00:04:01,550 --> 00:04:09,140
Instead of the total allocated budget, this total allocated budget is not making much sense.

42
00:04:10,120 --> 00:04:18,400
It would be better if we can display this percentage value on top of these two columns, so to do that,

43
00:04:19,180 --> 00:04:20,380
just select your.

44
00:04:21,940 --> 00:04:31,180
Data labels and here in label option, you have an option of what value should the data labels contain

45
00:04:31,330 --> 00:04:33,340
now here on the button?

46
00:04:34,290 --> 00:04:42,780
And click on value from cells here, you can select the cells which contain the value you want to display.

47
00:04:43,110 --> 00:04:45,420
So I want to display this percentages.

48
00:04:45,930 --> 00:04:47,920
So I have selected these two values.

49
00:04:48,270 --> 00:04:54,360
Now, once you have selected it, click on OK, and now you can see that we have this percentage value

50
00:04:54,480 --> 00:04:56,310
on top of our columns.

51
00:04:57,840 --> 00:05:02,580
Now, the only thing we need to correct here is the chart titled.

52
00:05:03,490 --> 00:05:04,570
So here.

53
00:05:07,690 --> 00:05:08,380
Will just.

54
00:05:10,180 --> 00:05:11,740
Copied on their own.

55
00:05:13,400 --> 00:05:14,980
Added this chart paper.

56
00:05:17,950 --> 00:05:21,520
So now over this chart is also ready in the next lecture.

57
00:05:21,550 --> 00:05:26,440
We will combine all of these four charts to create a dashboard like this.