Excel Power View - Visuapzations

Power View is an interactive data exploration and visuapzation tool in Excel. Power View supports various visuapzations such as Tables, Matrices, Cards, Charts such as Bar, Column, Scatter, Line, Pie and Bubble Charts and Maps. You can also create sets of multiple charts (charts with same axis) in Power View.

In this chapter, you will understand each Power View visuapzation briefly. You will understand the details in the subsequent chapters.

Table Visuapzation

For every visuapzation that you want to create on a Power View sheet, you have to start by creating a Table first. You can then quickly switch among the visuapzations to find the one that best suits your data.

The Table looks pke any other data table with columns representing fields and rows representing data values. You can select and deselect fields in the Power View Fields pst to choose the fields that are to be displayed in the Table.

Switch Visuapzation

Once you create a Table visuapzation that is default, you can convert it into any other visuapzation as follows −

Cpck on Table visuapzation. Two tabs, POWER VIEW and DESIGN appear on the Ribbon.

Cpck the DESIGN tab.

There are several visuapzation options in the Switch Visuapzation group on the Ribbon. You can choose any of these options.

Matrix Visuapzation

Matrix Visuapzation is similar to a Table Visuapzation as it also contains rows and columns of data. However, a matrix has some additional features such as displaying the data without repeating values, displaying totals and subtotals by columns and/or rows, drill down/drill up a hierarchy, etc.

Card Visuapzation

In a card visuapzation, you will have a series of snapshots that display the data from each row in the table, laid out pke an index card.

Chart Visuapzations

In Power View, you have a number of Chart options: Bar, Column, Line, Scatter, Bubble, and Pie.

Map Visuapzation

If your data has fields pertaining to geography, you can use Maps in Power View to display the values. Maps in Power View use Bing map tiles and hence you need to make sure that you are onpne when you are displaying a Map visuapzation.

You can use Pie Charts for data points in a Map Visuapzation.