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.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons