1
00:00:00,540 --> 00:00:08,610
In the last four lectures, we have created this for Doffs the line chart for our profit and profit

2
00:00:08,610 --> 00:00:09,130
margin.

3
00:00:09,750 --> 00:00:12,600
The bar chart for our historical revenue.

4
00:00:14,530 --> 00:00:17,800
The pie chart for our expense breakup and.

5
00:00:19,220 --> 00:00:25,190
Another column charged for tracking our advertisement and payroll expenses.

6
00:00:26,210 --> 00:00:32,710
Now let's create a dashboard like this to place all these four charts in one place.

7
00:00:33,960 --> 00:00:37,020
To start, I'm just creating a new tab.

8
00:00:38,470 --> 00:00:39,490
That's Kopi.

9
00:00:40,440 --> 00:00:41,430
On the charts.

10
00:00:59,790 --> 00:01:07,110
So these are the four charts we want to display on our dashboard right now, you can see that the size

11
00:01:07,110 --> 00:01:15,210
of these charts are not even the weight of this chart is smaller than the weight of these two charts.

12
00:01:16,080 --> 00:01:20,000
So first, let's make the size of these charts uniform.

13
00:01:20,670 --> 00:01:26,970
So just select the chart, go to format, and here you will see the height and weight option.

14
00:01:29,360 --> 00:01:35,120
To make it uniform, I will select a height of eight and a bit of well.

15
00:01:40,590 --> 00:01:44,730
I will select the similar dimension for other thoughts as well, so.

16
00:01:49,360 --> 00:01:51,780
High desert and with this 12.

17
00:01:54,210 --> 00:01:58,030
And also, I want tight as aid and the spread.

18
00:02:07,810 --> 00:02:12,310
You can see that we have corrected the size of all the charts.

19
00:02:14,330 --> 00:02:16,460
Now, one more thing you can notice is that.

20
00:02:17,280 --> 00:02:26,070
The charts are not completely aligned, so say this chart is a little bit higher than this chart, and

21
00:02:26,070 --> 00:02:34,140
the gap between these two charts may be different from the gap between these two charts, the gap in

22
00:02:34,140 --> 00:02:39,770
height between these two charts, maybe different from the gap in height in these two charts.

23
00:02:40,410 --> 00:02:47,250
Now, to arrange this chart, you have to select the two charts you want to arrange.

24
00:02:47,850 --> 00:02:50,310
So I have selected these two charts.

25
00:02:50,760 --> 00:02:53,030
I will try to align them in center.

26
00:02:53,400 --> 00:02:55,950
So once you select the chart, go to formate.

27
00:02:57,010 --> 00:03:03,180
Click on this Alane drop down menu and click on a line to middle.

28
00:03:07,680 --> 00:03:13,440
So once you click a line to model, you will see that both of these charts are aligned.

29
00:03:14,870 --> 00:03:18,460
Similarly, I will align these two charts as well.

30
00:03:21,260 --> 00:03:24,160
Go to a line and click on a line to middle.

31
00:03:27,770 --> 00:03:33,260
Now, you can see that the gap between these two is less than the gap between these two.

32
00:03:33,980 --> 00:03:39,530
So next, I will align these two charts again, go to formate.

33
00:03:41,290 --> 00:03:50,640
On the line this time, we need to align them to center, not to the middle, if we want to align them

34
00:03:50,880 --> 00:03:55,410
to a vertical center line, we need to select a lane center.

35
00:03:55,980 --> 00:04:02,220
If we want to align them to a horizontal line, we have to click on alignment.

36
00:04:02,580 --> 00:04:07,500
This time, we want to align them to a vertical center line.

37
00:04:07,890 --> 00:04:13,410
So we will click on Line Center so you can see that these two charts are normal.

38
00:04:13,410 --> 00:04:16,930
And similarly, we will align these two charts as well.

39
00:04:17,220 --> 00:04:21,900
So select the chart, go to forum and click on the line and click on a line to center.

40
00:04:22,930 --> 00:04:29,700
Now, these two charts are aligned to middle, these two charts are aligned to maintain these two charts

41
00:04:29,710 --> 00:04:33,010
at Atlanta Center and these two charts are aligned to center.

42
00:04:33,490 --> 00:04:38,620
So now all the charts are aligned and you can see that.

43
00:04:40,180 --> 00:04:46,960
The gap between all of these charts are now, even now, we will also remove the red lines.

44
00:04:47,200 --> 00:04:51,310
This red lines are useless for displaying charts.

45
00:04:54,280 --> 00:04:58,420
I am using a shortcut or W v d.

46
00:04:59,520 --> 00:05:02,880
You can also go to YouTube and unpick this gridline.

47
00:05:06,210 --> 00:05:13,050
So now let's add water to our dashboard, I will select this.

48
00:05:13,980 --> 00:05:14,940
All square.

49
00:05:16,700 --> 00:05:19,940
And I will add the background color to this.

50
00:05:25,090 --> 00:05:32,710
Now you can see that there is a large border over here as compared to here, so I just saw your column

51
00:05:32,710 --> 00:05:33,820
with accordingly.

52
00:05:46,260 --> 00:05:52,980
So now we have a little background to our dashboard now, Lazzara title to our title.

53
00:05:55,320 --> 00:06:04,050
To add titles like all the cells that are above your dashboard and then click on More Center.

54
00:06:05,450 --> 00:06:12,170
What this button will do is it will combine all the cells to create one single big cell.

55
00:06:13,440 --> 00:06:16,010
Now, you can read anything in this big cell.

56
00:06:16,320 --> 00:06:18,810
So, for example, I cannot find this.

57
00:06:20,370 --> 00:06:28,410
Baseball, so this is the title of our sport, I can increase the font size of this title.

58
00:06:29,330 --> 00:06:30,470
I can make it, boy.

59
00:06:32,490 --> 00:06:41,190
If you want, you can add furors on the top to make it more central, your line is now.

60
00:06:41,190 --> 00:06:47,070
You can see that we have created a dashboard, we have done formatting on this dashboard to make it

61
00:06:47,070 --> 00:06:48,870
look more visually appealing.

62
00:06:50,250 --> 00:06:56,080
So this was our initial dashboard and we have created this dashboard from scratch.

63
00:06:57,000 --> 00:07:00,150
You should also try to create this dashboard on your own.