Adding Location Intelligence with Power Map - Microsoft Business Intelligence Tools for Excel Analysts - page 119

Adding a top/bottom chart
The Power Map Add-In lets you add rudimentary charts to your maps. Although these charts don't
come with the full functionality of Power View or standard Excel charts, they do offer a relatively easy
way to expose the highest or lowest data points on your map.
To add a chart, click the 2D Chart button on the Power Map Ribbon. If your Power Map model has
more than one layer, you see a dialog box asking you to choose the layer for which you want to show
the chart. Otherwise, the chart is automatically created.
Power Map charts always show either the top or bottom locations based on the data used to
geocode and aggregate the data. For example, in Figure 6-19, the chart shows the top 100 locations
based on the Orders (Sum) by County.
After the chart is created, you can take the following actions:
➤ Resize the chart: Click it and use the resize handles.
➤ Switch between top and bottom: Click the word Top above the chart to toggle to the
bottom view.
➤ Change the number of columns displayed on the chart: Drag each end of the chart's slider
bar (or scroll bar). The smaller you make the slider bar, the fewer columns show in the chart
at one time.
➤ Change the chart type: Click the chart type drop-down menu next to the chart title.
Figure 6-19: Power Map charts offer a way to expose the highest and lowest locations based on the data used to
geocode and aggregate the data.