Using country codes for defining countries in filterable map charts allows for a more precise and flexible data representation. It enables you to showcase data from a specific country by selecting it from the dropdown. This is particularly useful in platforms like Google Sheets where map types are less dynamic. However, it's important to note that each country is defined by a country code, so you can change the country names to your preference.
This question was 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...
Go to dashboard to download stunning resources
Download
Text this question was asked on:
Finally, they're also filterable by country. To showcase data from a particular country, select it from the dropdown. Each country is defined by a country code on the Fields tab, so you can change the country names to whatever you want. This country filtering is important on the Google Sheets version, where the map types are less dynamic. But we'll explain this more later. Underneath the filters, the min and max ranges of your data are provided for more precise filtering.
Ask another question
Struggle with spreadsheet visualizations? Use our comprehensive charts template to save time and hours of work and create beautiful charts and graphs for reports and analysis. This template contains a variety of commonly used charts as well as dashboards for excellent and quick visualization.
Memorable visuals can persuade and motivate more than words ever do. Make your presentations more impactful with our all-new Video Backgrounds compilation, thematically presented with title suggestions. Use this selection of storytelling elements to complement your content and make your work all the more unforgettable.
Is your business eyeing a new market? Use our Market Entry Strategy presentation template to discover if a market expansion investment is worth it. Whether you want to enter a new geography, new sector, or new demographic, a strong market entry strategy is required to plan out the likelihood of success vs the cost of failure.
How to use market trends to bring in new business opportunities? This Market Research presentation provides tools that organize, present, and evaluate market insights that could lead to the next big ideas.
Use our Go-to-Market Strategy template to help launch your product. This presentation includes some of the best GTM tools such as: Product-Market Fit, Customer Value Maps, Product Growth Projection, Global Market Trends, Launch Status Dashboards, and more.
Tap into new markets and achieve higher returns for your investments. Use our Emerging Markets presentation to inspire expansion at global level for your organization and reap impressive rewards that outweigh market volatility.
We've created a new collection of more advanced and visually appealing spreadsheet charts to save hours of time. Included in this collection are: bar chart variations, sales funnel variations, pie chart variations, world map, step change charts, variance charts, scatter chart, and radar charts, all easily editable and conveniently linked to data input tables.
Enhance your presentations with detailed maps of regions that your business is involved in. With maps of hundreds of countries around the world, organized by continents, you can highlight what’s important to your market and even visualize your future expansion.
Microsoft Excel
Google Sheets