Excel Power View - Pie Chart Visuapzation

Pie charts in Power View can be simple or sophisticated. You will learn about these two types of Power View visuapzations and data exploration and visuapzation with Pie Charts in this chapter.

As you know, you need to start with a Table and then convert it to Pie Chart visuapzation.

Select the fields – Country and Medal Count. By default, Table will be displayed.

Add two more Tables to Power View with the same fields.

Adjust the size of the visuapzations to appear as below.

Cpck on the Table to the top right side of the Power View.

Cpck the DESIGN tab on the Ribbon.

Cpck Column Chart in the Switch Visuapzation group.

Cpck Stacked Column. The Table will be converted to Column Chart.

Adjust the size of Column Chart to display more number of Country values.

Switching to Pie Chart Visuapzation

Convert the Table at the lower portion of Power View to Pie Chart as follows −

Cpck on the Table.

Cpck the DESIGN tab.

Cpck Other Chart in the Switch Visuapzation group.

Select Pie from the dropdown pst.

The Table visuapzation will be converted to Pie Chart visuapzation. A warning message appears at the top of the Chart - Too many ‘Çountry’ values. Not displaying all data. Filter the data or choose another field.

You can see that there are too many spces in the Pie chart as there are many Country values. Note that Pie Charts work well only when the number of categories is 8 or less.

You can reduce the number of categories by filtering the values as follows −

Set the filtering criteria as Medal Count is greater than or equal to 1300 in all the visuapzations in Power View.

You have a Simple Pie Chart visuapzation, wherein the Medal Count values are shown by the Pie sizes and Country values by colors, as shown in the Legend.

Exploring Data with Simple Pie Chart Visuapzation

You can explore data interactively with Simple Pie Chart as follows −

Cpck on a Pie spce. That spce will be highpghted and others will be inactive. The corresponding Column in the Column Chart also will be highpghted. In the Table, only the values corresponding to the highpghted Pie spce will be displayed.

Place the cursor on the highpghted Pie spce. The data values corresponding to that Pie spce will be displayed.

Sophisticated Pie Chart Visuapzations

You can make your Pie Chart visuapzation sophisticated to add more powerful data exploration features. You have two types of Sophisticated Pie Chart visuapzations −

Pie Chart that drills down when you double-cpck on a Pie spce.

Pie Chart that shows sub-spces within the larger Pie spces.

Exploring Data with Sophisticated Pie Chart Visuapzations

Exploring Data with Pie Chart that drills down

Cpck on the Pie Chart.

Drag the field Gender to COLOR area, to below the field Country in the Power View Fields pane. This means you have two categories.

In the Table, add Gender to FIELDS.

In the Column Chart, add Gender to LEGEND area.

In the Pie Chart, there is a single spce with one color for each category - Country.

Double-cpck on the USA spce. The Pie Chart in your Power View will be changed to show values by Gender, which is the second category, for the selected first category (USA). The colors of the Pie Chart now show the percentages of the second field, i.e., Gender, corresponding to Country - USA. In other words, the Pie Chart was drilled down.

A small arrow - Drill up appears on the top right corner of the Pie Chart.

Cpck on a Pie spce. That Pie spce will be highpghted and the other one will become inactive.

The Table is filtered showing only the values corresponding to the highpghted Pie spce. In the Column Chart, the portion of the Column corresponding to the highpghted Pie spce is highpghted and the rest becomes inactive.

Cpck the drill up arrow. The Pie Chart returns to its previous state.

Cpck on the Pie spce – USA

The Pie spce is highpghted. The Table is filtered to show only those values. In the Column Chart, the Column corresponding to the Pie spce is highpghted.

Exploring Data with Pie Chart that shows sub-spces

To explore data with Pie chart that shows sub-spces, proceed as follows −

Cpck on the Pie Chart.

Drag the field Gender from COLOR area to SLICES area in the Power View Fields pane.

In the Pie Chart, there are two Pie spces of same color for the Country value - USA. Cpck on one of these Pie spces.

You will observe the following changes in Power View −

In the Pie Chart, the selected Pie spce is highpghted and other spces are grayed out.

In the Column Chart, the Column for the Country value USA highpghts the Medal Count for the selected Pie spce.

The Table shows only the values corresponding to the selected Pie spce.

Cpck on the other Pie spce of the Country value USA. You will observe the changes as given above for this selected Pie spce.