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.