Build a map of the united states in a spread sheet

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.

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.

Asked on the following spreadsheet:

resource preview

Ultimate World Map Collection

Need to create map charts in Excel or Google Sheets? Our Ultimate World Map Collection includes a filterable world map chart, filterable map charts fo...

file_save

Download free weekly spreadsheets

Enter your email address to download and customize spreadsheets for free

Not for commercial use

OR
file_save

Download 'Ultimate World Map Collection ' spreadsheet — 22 sheets

Ultimate World Map Collection

+39 more spreadsheets per quarter

that's $3 per spreadsheet

$117

/ Quarterly

Commercial use allowed. View other plans

Preview (22 sheets)

View all chevron_right