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,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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.