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

Click the drop-down arrow next to your quantitative field (see Figure 6-10) to select a different
aggregation type. Power Map defaults to Sum in most cases, but you can select Average, Count,
Maximum, Minimum, or No Aggregation. You can also select Remove to remove the field.
Figure 6-10: Click the drop-down arrow next to your quantitative field to select a different aggregation type.
Visualization types
In terms of visualization types, you can choose Column, Bubble, Heat Map, or Region. Simply click the
drop-down arrow in the Type field to select the one you want.
Column
The Column visualization type lets you present your quantitative values as columns with varying
heights. This is the default type. You can format the columns by clicking the Scene Options icon
(it looks like a gear) in the Layer Manager task pane. As shown in Figure 6-11, the Layer Options allow
you to adjust the overall height and thickness of the columns; change the color of the columns; and
specify whether to show zeroes, negative values, or nulls.