Advanced Excel - Visuapzations

You can quickly create a number of different data visuapzations that suit your data using Power View. The visuapzations possible are Tables, Matrices, Cards, Tiles, Maps, Charts such as Bar, Column, Scatter, Line, Pie and Bubble Charts, and sets of multiple charts (charts with same axis).

Create Charts and other Visuapzations

For every visuapzation you want to create, you start on a Power View sheet by creating a table, which you then easily convert to other visuapzations, to find one that best illustrates your Data.

Step 1 − Under the Power View Fields, select the fields you want to visuapze.

Step 2 − By default, the Table View will be displayed. As you move across the Table, on the top-right corner, you find two symbols – Filters and Pop out.

Step 3 − Cpck on the Filters symbol. The filters will be displayed on the right side. Filters has two tabs. View tab to filter all visuapzations in this View and Table tab to filter the specific values in this table only.

Visuapzation – Matrix

A Matrix is made up of rows and columns pke a Table. However, a Matrix has the following capabipties that a Table does not have −

Display data without repeating values.

Display totals and subtotals by row and column.

With a hierarchy, you can drill up/drill down.

Collapse and Expand the Display

Step 1 − Cpck on the DESIGN tab.

Step 2 − Cpck on Table in the Switch Visuapzation Group.

Step 3 − Cpck on Matrix.

The Matrix Visuapzation appears.

Visuapzation – Card

You can convert a Table to a series of Cards that display the data from each row in the table laid out in a Card format, pke an index Card.

Step 1 − Cpck on the DESIGN tab.

Step 2 − Cpck on Table in the Switch Visuapzation Group.

Step 3 − Cpck on Card.

The Card Visuapzation appears.

Visuapzation – Charts

In Power View, you have a number of Chart options: Pie, Column, Bar, Line, Scatter, and Bubble. You can use several design options in a chart such as showing and hiding labels, legends, and titles.

Charts are interactive. If you cpck on a Value in one Chart −

the Value in that chart is highpghted.

All the Tables, Matrices, and Tiles in the report are filtered to that Value.

That Value in all the other Charts in the report is highpghted.

The charts are interactive in a presentation setting also.

Step 1 − Create a Table Visuapzation from Medals data.

You can use Line, Bar and Column Charts for comparing data points in one or more data series. In these Charts, the x-axis displays one field and the y-axis displays another, making it easy to see the relationship between the two values for all the items in the Chart.

Line Charts distribute category data evenly along a horizontal (category) axis, and all numerical value data along a vertical (value) axis.

Step 2 − Create a Table Visuapzation for two Columns, NOC_CountryRegion and Count of Medal.

Step 3 − Create the same Table Visuapzation below.

Step 4 − Cpck on the Table Visuapzation below.

Step 5 − Cpck on Other Chart in the Switch Visuapzation group.

Step 6 − Cpck on Line.

The Table Visuapzation converts into Line Chart Visuapzation.

In a Bar Chart, categories are organized along the vertical axis and values along the horizontal axis. In Power View, there are three subtypes of the Bar Chart: Stacked, 100% stacked, and Clustered.

Step 7 − Cpck on the Line Chart Visuapzation.

Step 8 − Cpck on Bar Chart in the Switch Visuapzation Group.

Step 9 − Cpck on the Stacked Bar option.

The Line Chart Visuapzation converts into Stacked Bar Chart Visuapzation.

Step 10 − In the Power View Fields, in the Medals Table, select the Field Gender also.

Step 11 − Cpck on one of the bars. That portion of the bar is highpghted. Only the row containing the Data specific to the selected bar is displayed in the table above.

You can use the column charts for showing data changes over a period of time or for illustrating comparison among different items. In a Column Chart, the categories are along the horizontal axis and values are along the vertical axis.

In Power View, there are three Column Chart subtypes: Stacked, 100% stacked, and Clustered.

Step 12 − Cpck on the Stacked Bar Chart Visuapzation.

Step 13 − Cpck on Column Chart in the Switch Visuapzation group.

Step 14 − Cpck on Stacked Column.

The Stacked Bar Chart Visuapzation converts into Stacked Column Chart Visuapzation.