If you need to make a map chart that shows sales by country, how should you set up the data?
Understand the Problem
The question is asking for the appropriate setup of data to create a map chart that displays sales by country. It requires evaluating different column setups to determine the most effective way to visually represent sales data geographically.
Answer
The first column should contain country names, and the second column should have the sales amounts for each country.
The first column should contain country names, and the second column should have the sales amounts for each country.
Answer for screen readers
The first column should contain country names, and the second column should have the sales amounts for each country.
More Information
To set up a map chart in Excel, you typically need a column for geographic data (like country names) and another column for data to visualize (such as sales).
Tips
A common mistake is not having uniform geographical names. Ensure they match recognized country names.
Sources
- Create a Map chart in Excel - Microsoft Support - support.microsoft.com
