1
00:00:00,000 --> 00:00:05,740
A pie chart is a circular data
visualization divided into segments.

2
00:00:05,740 --> 00:00:08,180
Each segment represents parts of a whole.

3
00:00:09,260 --> 00:00:12,100
A pie chart displays percentages.

4
00:00:12,100 --> 00:00:17,964
Each section of the circle represents
a value set to a percentage out of 100.

5
00:00:19,840 --> 00:00:24,600
For our pie chart, we will be
using the South America data set.

6
00:00:24,600 --> 00:00:27,554
On my first observation
about the population data,

7
00:00:27,554 --> 00:00:30,800
something significant stands out to me.

8
00:00:30,800 --> 00:00:33,390
There are a lot of people
who live in Brazil.

9
00:00:33,390 --> 00:00:37,618
Their population is an order of magnitude
greater than the rest of the most

10
00:00:37,618 --> 00:00:40,630
populated South American countries.

11
00:00:40,630 --> 00:00:45,300
What percentage of people who live in
South America are living in Brazil?

12
00:00:45,300 --> 00:00:50,019
A pie chart will give us a snapshot answer
to the questions about proportions of

13
00:00:50,019 --> 00:00:50,600
a whole.

14
00:00:51,850 --> 00:00:59,190
In my workbook, I can select column A for
country and column B for population.

15
00:01:00,600 --> 00:01:04,040
Remember to hold down command or
control while you click on column B.

16
00:01:06,040 --> 00:01:07,738
Then we can insert a chart.

17
00:01:12,332 --> 00:01:16,238
Let's first explore
the data as a column chart.

18
00:01:16,238 --> 00:01:20,294
In the chart editor,
I'll go to my setup tab,

19
00:01:20,294 --> 00:01:24,560
chart type, and scroll down for
a column chart.

20
00:01:26,681 --> 00:01:30,720
Well, this tells the story that there
are a lot of people living in Brazil.

21
00:01:32,020 --> 00:01:35,619
But it doesn't tell us much about
the composition of all of the countries

22
00:01:35,619 --> 00:01:36,210
as a whole.

23
00:01:37,700 --> 00:01:40,600
So, let's change the chart type
again in the chart editor.

24
00:01:42,380 --> 00:01:44,982
Scroll down and select the pie chart.

25
00:01:48,625 --> 00:01:51,698
And right away now
there's an obvious trend

26
00:01:51,698 --> 00:01:56,610
to observe that almost half the people
in South America are in Brazil.

27
00:01:58,130 --> 00:02:02,120
Our pie chart looks okay but there are a
couple things we can do to make it better.

28
00:02:03,220 --> 00:02:05,095
First, let's fix up that title.

29
00:02:05,095 --> 00:02:08,715
Double click the chart title and
change it in the chart editor.

30
00:02:14,020 --> 00:02:21,140
I'll clarify that this is South America
Population 2020, and center the title.

31
00:02:24,770 --> 00:02:28,320
We can clean up the presentation
of the pie chart now.

32
00:02:28,320 --> 00:02:33,440
First, deselect columns A and B by
clicking away on any non selected cell.

33
00:02:35,690 --> 00:02:39,993
Then right click on column B and
you can sort the sheet from A to Z or

34
00:02:39,993 --> 00:02:41,922
Z to A whichever you prefer.

35
00:02:46,190 --> 00:02:49,650
Next, let's go to the chart
editor's customize tab.

36
00:02:57,392 --> 00:03:02,085
Click on the section pie chart and
then the drop down menu for slice label.

37
00:03:02,085 --> 00:03:06,113
I'm going to choose value and
percentage because it labels the chart

38
00:03:06,113 --> 00:03:09,250
with information relevant
to my original question.

39
00:03:11,310 --> 00:03:16,500
How many people and what proportion of
South American people live in Brazil?

40
00:03:16,500 --> 00:03:21,469
The answer is 213 million people or 49.4%.

41
00:03:22,970 --> 00:03:26,120
Let's include these insights
in some alternative text.

42
00:03:28,560 --> 00:03:31,417
Click on the chart and

43
00:03:31,417 --> 00:03:36,190
the chart options menu, Alt text.

44
00:03:36,190 --> 00:03:42,718
For our title,
South America Population 2020, and

45
00:03:42,718 --> 00:03:48,022
for our descriptive
analysis Brazil composes

46
00:03:48,022 --> 00:03:54,290
almost half of the total
population of South America.

47
00:03:55,330 --> 00:03:59,943
There are 213 million
people living in Brazil.

48
00:03:59,943 --> 00:04:04,558
Once we're done with our alternative text,
we'll move this chart to a new sheet and

49
00:04:04,558 --> 00:04:05,473
rename the sheet

50
00:04:15,890 --> 00:04:18,708
I'll call this South America Pie Chart.

51
00:04:22,123 --> 00:04:24,380
Now it's your turn again.

52
00:04:24,380 --> 00:04:29,770
Make a pie chart with either the Central
America, or Caribbean data sets.

53
00:04:29,770 --> 00:04:33,565
Remember to filter for a year if
you choose the Caribbean set, and

54
00:04:33,565 --> 00:04:35,850
don't forget your alternative text.