Which method would create a 3D Map that shows columns for the total sales in each city?
Understand the Problem
The question is asking about the process for creating a 3D Map that visually represents total sales for various cities, specifically which field to drag into which part of the software interface.
Answer
Drag the Sales field to the Height box in the Layer pane.
The correct method is to drag the Sales field to the Height box in the Layer pane.
Answer for screen readers
The correct method is to drag the Sales field to the Height box in the Layer pane.
More Information
3D Maps in Excel allow you to visualize geographical data and showcase metrics with spatial dimensions effectively.
Tips
A common mistake is confusing the Location and Height fields. Ensure geographical data goes in 'Location' and numerical values in 'Height'.
Sources
- Get started with 3D Maps - Microsoft Support - support.microsoft.com
- Create a 3-D Power Map in Excel - Pryor Learning - pryor.com