How do you delete or hide the data for other countries to only display the United States?

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:

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

$132

/ Quarterly

Commercial use allowed. View other plans

Preview (22 sheets)

View all chevron_right