Enter your email address to download and customize spreadsheets for free
To display only the United States in your map chart, you need to delete or hide the data for other countries.
In Excel:
1. Click on the cell or column that contains the data for other countries.
2. Right-click and select 'Delete' or 'Hide' from the dropdown menu.
In Google Sheets:
1. Select the cells or columns containing the data for other countries.
2. Right-click and choose 'Delete cells' or 'Hide column' from the context menu.
Remember, deleting data will permanently remove it from your spreadsheet, while hiding it will simply make it invisible until you choose to 'Unhide' it.
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:
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...
Download free weekly spreadsheets
Enter your email address to download and customize spreadsheets for free
Not for commercial use
Download 'Ultimate World Map Collection ' spreadsheet — 22 sheets
+39 more spreadsheets per quarter
that's $3 per spreadsheet
/ Quarterly
Commercial use allowed. View other plans