Page 722 - Excel 2013 All-in-One For Dummies

704 Using the PowerPivot and Power View Add-Ins
Figure 2-19:
Using
the Map feature in Power View
to compare sales by country.
You then select the fields from related tables listed in the Power View Fields task pane that you want visually represented in the Power View report. Power View then displays the data for the selected fields graphically as small tables on the Power View worksheet, while at the same time selecting a Design tab on the Ribbon that contains a Switch Visualization group with these options:
✦ Table to represent the selected dataset in the Power View sheet in the default tabular view after applying one of the other visualization options to the dataset
✦ Bar Chart to represent the selected dataset in the Power View sheet as some sort of bar chart
✦ Column Chart to represent the selected dataset in the Power View sheet as some sort of column chart
✦ Other Chart to represent the selected dataset in the Power View sheet as some other type of chart
✦ MaptorepresenttheselecteddatasetinthePowerViewsheetasdifferent sized circles on a map of the world