A geochart creates a map of regional points based on a column value in Google Sheets. In this video, author Jess Stratton shows how to create a geochart and then add further formulas to make it interactive.
- [Narrator] Google Sheets comes with the ability…to create a GeoChart already built in.…There's no formulas required,…in it's simplest way, to make a Geo Chart.…First, select the column…that contains the geographic information.…In this case, it's a list of states.…This sheet is a list of registrants for people…that are going to be attending a conference.…I'd like to find out how many people from each state…are coming to the conference.…I'll start by selecting the column,…I'll choose Insert, then select Chart,…and it's going to recommend a particular type of chart.…
I can manually override that recommendation…by clicking on the Chart types tab.…From here, I'll scroll all the way near the bottom…and select Map.…It's going to contain a GeoChart.…And it's the Customization tab…that really lets it show it's power.…I can change the background color of the chart.…I can also change what aggregate type it is.…Here's where I select the Region of the chart.…It defaults to the world.…But I can choose which continent or area I want,…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.