1
00:00:00,00 --> 00:00:03,400
Peace be upon you and greetings

2
00:00:03,500 --> 00:00:04,400
welcome to the video

3
00:00:04,500 --> 00:00:08,300
so today we will learn how to create pie 
chart from google sheet

4
00:00:08,400 --> 00:00:10,000
so we will search google sheet here

5
00:00:10,100 --> 00:00:12,900
at google and we click this

6
00:00:13,000 --> 00:00:14,400
ok, first

7
00:00:14,500 --> 00:00:17,900
to make pie chart on google sheet

8
00:00:18,000 --> 00:00:19,200
we need

9
00:00:19,800 --> 00:00:22,500
to fill this column here

10
00:00:22,600 --> 00:00:25,500
to be a guide

11
00:00:25,600 --> 00:00:27,900
that we will put in

12
00:00:28,000 --> 00:00:32,800
we must fill here .the sample

13
00:00:32,900 --> 00:00:36,800
that we want to be in our pie chart

14
00:00:36,900 --> 00:00:39,300
for example, I will put

15
00:00:42,700 --> 00:00:44,000
sample A here

16
00:00:46,100 --> 00:00:51,500
and here I will put Sample B

17
00:00:51,600 --> 00:00:54,700
and here I will put Sample C

18
00:00:57,200 --> 00:00:59,600
D and...

19
00:00:59,700 --> 00:01:01,400
E

20
00:01:05,900 --> 00:01:07,200
ok

21
00:01:08,100 --> 00:01:11,500
so we have fill our first column

22
00:01:11,600 --> 00:01:13,000
which is column A

23
00:01:13,100 --> 00:01:15,000
that is our

24
00:01:15,100 --> 00:01:16,000
sample

25
00:01:16,100 --> 00:01:17,500
so...

26
00:01:18,900 --> 00:01:21,300
after we fill the title

27
00:01:21,400 --> 00:01:23,000
that will be put in pie chart

28
00:01:23,100 --> 00:01:25,000
for every column here

29
00:01:25,100 --> 00:01:27,200
we will put the percentage

30
00:01:28,100 --> 00:01:30,700
I will put 20 percentage here

31
00:01:30,800 --> 00:01:33,000
15 percentage

32
00:01:34,200 --> 00:01:35,200
15

33
00:01:37,700 --> 00:01:39,200
25

34
00:01:39,300 --> 00:01:39,900
and..

35
00:01:40,000 --> 00:01:41,300
25.. orait

36
00:01:41,400 --> 00:01:42,600
so

37
00:01:42,700 --> 00:01:47,500
the total percent that we put in our sample 
must

38
00:01:48,600 --> 00:01:50,500
be 100

39
00:01:50,600 --> 00:01:53,500
because if it not..

40
00:01:53,600 --> 00:01:55,000
...if..

41
00:01:55,100 --> 00:01:57,600
more or less

42
00:01:57,700 --> 00:01:59,900
from 100

43
00:02:00,000 --> 00:02:04,800
the pie chart that we made will not be same

44
00:02:04,900 --> 00:02:06,200
it will automatically adjust

45
00:02:06,300 --> 00:02:09,300
to reach 100 percent

46
00:02:09,400 --> 00:02:14,200
to put all our sample to be in pie chart

47
00:02:14,300 --> 00:02:15,700
we will

48
00:02:15,800 --> 00:02:20,600
select all the percentage and sample

49
00:02:20,700 --> 00:02:24,200
and click the three dot at the right

50
00:02:24,300 --> 00:02:26,100
and click "insert Chart"

51
00:02:29,400 --> 00:02:29,800
ok

52
00:02:30,900 --> 00:02:33,000
Pic chart will be appear

53
00:02:33,100 --> 00:02:37,900
and it will automatically what we put here 
will be in our pie chart

54
00:02:38,000 --> 00:02:39,200
ok. what i just talking about just now

55
00:02:39,300 --> 00:02:42,800
if the total here is not 100

56
00:02:45,500 --> 00:02:47,700
it will auotomatic adjust

57
00:02:47,800 --> 00:02:50,900
so this pie chart will be 100

58
00:02:51,000 --> 00:02:51,700
for example..

59
00:02:51,800 --> 00:02:55,900
I will put here not 25 but 30

60
00:02:56,000 --> 00:03:01,100
if we total all of this we will see that 
all of this is 105

61
00:03:01,200 --> 00:03:02,900
and if I push enter

62
00:03:03,000 --> 00:03:03,700
see?

63
00:03:03,800 --> 00:03:07,600
tha percentage here is not same with here

64
00:03:07,700 --> 00:03:13,500
because the percentage for this pie chart 
will be still 100

65
00:03:13,600 --> 00:03:14,100
but here is not

66
00:03:14,200 --> 00:03:14,700
so

67
00:03:14,800 --> 00:03:19,600
it will difficult for us

68
00:03:21,000 --> 00:03:28,900
so I recommend you to put all of this is 
total 100

69
00:03:29,000 --> 00:03:33,800
so after we finish here

70
00:03:33,900 --> 00:03:41,300
now we can adjust or customize by double 
click on our pie chart

71
00:03:41,400 --> 00:03:46,200
and the setting will be appear on the right 
screen so..

72
00:03:46,300 --> 00:03:51,100
we can adjust colour from blue

73
00:03:51,200 --> 00:03:56,000
to cyan

74
00:03:56,100 --> 00:04:00,900
and we can adjust type of pie chart

75
00:04:01,000 --> 00:04:07,500
all type of pie chart that we see which is 
provide by google

76
00:04:07,600 --> 00:04:10,800
so you can change whatever you want

77
00:04:10,900 --> 00:04:15,700
ok, that's all from me

78
00:04:15,800 --> 00:04:18,900
goodbye and have a nice day