If you need to make a map chart that shows sales by country, how should you set up the data?

Question image

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

Thank you for voting!
Use Quizgecko on...
Browser
Browser