1
00:00:00,120 --> 00:00:04,190
Now, this time, we will create the pie chart for our expense.

2
00:00:07,750 --> 00:00:15,160
So this is the break up of expense, we have cost of goods sold, advertising, payroll interests and

3
00:00:15,160 --> 00:00:15,670
others.

4
00:00:16,150 --> 00:00:18,980
Now there is a separate break up of others.

5
00:00:19,360 --> 00:00:24,070
For now, we will be only using these values to create our chart.

6
00:00:25,390 --> 00:00:27,760
Want to create a pie chart, select your data.

7
00:00:29,330 --> 00:00:30,380
Go to insert.

8
00:00:32,850 --> 00:00:38,910
Click on this insert by a dropdown and here select this to by.

9
00:00:45,160 --> 00:00:48,040
Oh, you can see that we are getting this by Richard.

10
00:00:49,980 --> 00:00:58,620
Where this blew by is cost of goods sold, this orange pie is advertising, this great is payroll,

11
00:00:59,250 --> 00:01:01,050
this YellowPages interest.

12
00:01:01,050 --> 00:01:06,780
And we have some other entries in this dark gloopy.

13
00:01:09,600 --> 00:01:13,060
The title of this chart is Expense Breakup.

14
00:01:13,710 --> 00:01:16,680
So I will copy this from here.

15
00:01:17,940 --> 00:01:21,570
And then peace in the world of.

16
00:01:23,470 --> 00:01:30,550
Now, one thing you can clearly notice is that you can identify which one is the biggest spy, but it

17
00:01:30,550 --> 00:01:36,430
is very difficult for us to identify what are the values of these spies.

18
00:01:37,460 --> 00:01:46,400
So, for example, we can say that this loop is around 55 to 60 percent because it is covering more

19
00:01:46,400 --> 00:01:53,170
than half of the circle, but we don't know the exact value of this base.

20
00:01:54,140 --> 00:02:00,440
So just to make this chart more informative, we can add data levels.

21
00:02:02,090 --> 00:02:06,380
So click on this plus icon and click on this data labels.

22
00:02:10,590 --> 00:02:12,090
Now in your chart.

23
00:02:13,510 --> 00:02:18,710
You will have these values which are exactly conveying the values of this base.

24
00:02:19,570 --> 00:02:26,710
Now, most of these buyers are of darker color and black is not really visible.

25
00:02:26,890 --> 00:02:31,030
So we can select and change the color of this text.

26
00:02:32,100 --> 00:02:40,050
So select all the boxes by just clicking and click on this icon to change the color, I am choosing

27
00:02:40,050 --> 00:02:40,440
white.

28
00:02:43,180 --> 00:02:46,810
And I am also increasing the size of this.

29
00:02:51,800 --> 00:02:59,300
Now, the message we want to convey here is that advertisement and payroll are a huge chunk of our expense

30
00:02:59,300 --> 00:03:06,230
pie, and we want to direct the attention of other people towards these two segments or pays.

31
00:03:08,260 --> 00:03:17,050
So to make these two categories stand out, we can build this pace a little bit out.

32
00:03:18,100 --> 00:03:24,460
So that people can easily see that we want to highlight these two pice.

33
00:03:30,100 --> 00:03:34,510
So just hold and build the base a little bit outwards.

34
00:03:36,370 --> 00:03:39,940
So our expense pie chart is also pretty.