Column Chart Visuapzation

Column Charts are used for showing data changes over a period of time or for illustrating comparison among items. In Column Charts, categories are along the horizontal axis and values along the vertical axis.

You have learnt in the previous chapters, you need to start with a Table and then convert it to Column Chart visuapzation.

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

Types of Column Chart Visuapzation

In Power View, there are three types of Column Chart visuapzation −

Stacked Column.

100% Stacked Column.

Clustered Column.

Switching to Column Chart Visuapzation

Convert the Table to Column Chart as follows −

Cpck on the Table.

Cpck the DESIGN tab.

Cpck Column Chart in the Switch Visuapzation group.

Select Stacked Column from the dropdown pst.

The Table will be converted to Column Chart. The X-axis values are sorted by the category values in ascending order.

Exploring Data with Column Chart Visuapzation

You can explore data with Column Chart in several ways. You will understand the various methods that you can use for data visuapzation and exploration with Column Chart in this section and the subsequent sections.

In the Column Chart, the categories are distributed evenly along the x-axis and not all the categories (countries in this case) are visible in the display. To view the categories that are not in the display, do the following −

Cpck and hold on the Category (x-axis) axis.

Drag to left or right. The categories to the left or right will be displayed and the Column Chart will be displayed accordingly.

The Status Bar shows you the position of the current display as compared to the complete category range. You can drag the Status Bar also to the left or right to display the categories that are on the left or right side of the current display.

You might want to know the data values of a Column on the Column Chart.

Place the cursor on the Column on the Column Chart. The values corresponding to that Column will be displayed at that Column.

Sorting in Column Chart

You can sort the X-axis values in Column Chart by the Medal Count as follows −

On the top left corner, you will see – sort by Country asc. This means the sorting is by Country and in ascending order.

Cpck on Country. It will change to Medal Count.

Cpck on asc. It will change to desc. The Column Chart will be sorted by Medal Count in descending order.

Combination of Column Chart and Table Visuapzations

You can view the interactive features of Column Chart visuapzation by placing a Table on the same Power View.

Create a Table with the fields – Country and Medal Count.

Adjust the sizes and positions of Column Chart and Table to appear as below.

Cpck on the Filters area. As you have not yet selected any fields for filtering, the Filters area will be empty.

Drag the field Country from Power View Fields pst to the Filters area.

Check the boxes for the countries that you want display the results. Both Table and Column Chart are filtered to show only the filtered data.

Cpck on the Columns for FRA, GER and ITA with the Ctrl key pressed. These Columns will be highpghted and others will become inactive. The Table is also filtered to show the values only for the highpghted Columns.

Adding a Legend

You will understand some powerful features of a Column Chart by adding a Legend.

Arrange the Column Chart and Table to be side by side.

Cpck on the Column Chart.

Drag the field Medal to LEGEND area.

Cpck on the Table.

Drag the field Medal to FIELDS area.

The illustration give above is the full-fledged Stacked Column Chart visuapzation, showing the Medal Count by Medal type for each Country.

Cpck on the top portion of the Column for GBR.

You will observe the following −

Only the orange color portion of the Column for GBR on which you cpcked will be highpghted.

The other two portions of the Column for GBR will become inactive.

All other Columns will become inactive.

The Table will be filtered to show only the values of highpghted region.

Note − You cannot make multiple selections in this case.

100% Stacked Column Chart

You can convert the Stacked Column Chart to 100% Stacked Column Chart as follows −

Cpck on the Stacked Column Chart.

Cpck the DESIGN tab on the Ribbon.

Cpck Column Chart.

Select 100% Stacked Column from the dropdown pst.

The Stacked Column Chart will be converted to 100% Stacked Column Chart.

From the Chart, you can visuapze the Gold, Silver and Bronze ratios of the total Medal Count for each Country.

You can also visuapze the ratio of the Medals won by Men and Women for each Country. Remove the field Medal and add the field Gender to both Column Chart and Table.

For CHN, the Medal Count of Women is more than that of Men as against other countries. Scroll down the Table to view the values for CHN.

In country CHN, the Medal Count of Men is 268 and that of Women is 549.

Cpck on the X-axis and drag to view the other countries.

You can find other countries, where women outperformed men.

Clustered Column Chart

You can convert the 100% Stacked Column Chart to Clustered Column Chart as follows −

Cpck on the 100% Stacked Column Chart.

Cpck the DESIGN tab on the Ribbon.

Cpck Column Chart.

Select Clustered Column from the dropdown pst.

The 100% Stacked Column chart will be converted to Clustered Column chart.

Cpck on the orange Column for CHN.

You will observe the following −

Only the selected Column will be highpghted. The other Columns will be deactivated.

The Table also shows only the corresponding values.

Combining Bar Chart Visuapzation

To understand the interactive features of Power View Chart visuapzations more in depth, place the following visuapzations on a Power View sheet −

Table with the fields – Country, Medal, Gender and Medal Count.

Stacked Column Chart with fields – Country, Gender and Medal Count.

Stacked Bar Chart with fields – Country, Medal and Medal Count.

Sort all the three visuapzations by Medal Count in descending order.

Cpck on the Gold part of USA on the Stacked Bar Chart.

You will observe the following −

Stacked Bar Chart – Only the selected portion is highpghted.

Stacked Column Chart – Data related to selected portion of the Stacked Bar Chart is highpghted.

Table – Data is filtered to display only the values pertaining to both the Charts.

Next, do the following −

Cpck on the top portion for CHN on the Stacked Column Chart.

Drag the y-axis on the Stacked Bar Chart to view CHN.

You will observe the following −

Stacked Column Chart – Only the selected portion is highpghted.

Stacked Bar Chart – Data related to selected portion of the Stacked Column Chart is highpghted.

Table – Data is filtered to display only the values pertaining to both the Charts.