Question
To build a map of the United States in a spreadsheet, you can use the GeoChart feature in Google Sheets or the Map Chart feature in Excel.
In Google Sheets:
1. Enter your data in two columns. The first column should contain state names and the second column should contain the data you want to visualize.
2. Select your data and click on Insert > Chart.
3. In the Chart Editor, select the Chart Type as GeoChart.
In Excel:
1. Enter your data in two columns. The first column should contain state names and the second column should contain the data you want to visualize.
2. Select your data and click on Insert > Maps > Filled Map.
Remember, your data should be accurate and the state names should be spelled correctly for the map to be generated properly.
This question was asked on:
Need to create map charts in Excel or Google Sheets? We've created a template in Excel and Google Sheets that you can download and customize to your needs. It includes a world map chart, map charts for each major continent, including North America, South America, Asia, Europe, Africa, and Oceania, as well as a map chart for the United States, which on Excel can be customized to any country that's needed, which we'll get into later.
Receive new free presentations every Monday to your inbox.
Full content, complete versions — No credit card required.
