Exploring Data with Power View Charts - Excel Data Analysis

What is Exploring Data with Power View Charts?

In power View, you have got a number of Chart options: Pie, Column, Bar, Line, Scatter, and Bubble. The Charts in power View are interactive. if you click on on a value in one chart −

  • That value in that chart is highlighted.
  • That value in all of the other charts in power View is also highlighted.
  • All the tables, matrices and tiles in power View are filtered to that value.

Consequently, power View Charts serve as interactive, pictorial data analysis tools. Similarly, the charts are interactive in a presentation putting also, which could permit you to highlight the analysis effects.

Exploring with Line Charts

You may use Line charts for comparing data points in one or more data collection. Line charts distribute category data evenly along a horizontal (category) axis, and all numerical value information along a vertical (value) axis.

Assume you need to show the Medal depend for each country.

  • Create a power View with the fields NOC_CountryRegion and Medal depend selected. through default, table can be displayed.
  • Click on the table.
  • Click on different Chart within the switch Visualization group.
  • Choose Line from the drop-down list. Line Chart can be displayed in the power View.

Exploring Data with Power View Charts

  • Click on the line or the class (x-axis) axis.
  • Drag to left or right. the types to the left or right can be displayed and Line chart may be displayed accordingly.
  • Place the cursor on any of the data points on the line.

The values similar to that data point can be displayed at that point.

Exploring Data with Power View Charts

Exploring with Bar Charts

You can use Bar charts for comparing data points in one or more data collection. In a Bar chart, categories are prepared along the vertical axis and values along the horizontal axis. In power View, there are three Bar chart subtypes −

  • Stacked Bar.
  • 100% Stacked Bar.
  • Clustered Bar.

You may convert a table Visualization to Bar Chart Visualization as follows −

  • Create two table visualizations side-by-side.
  • Click the right table.
  • Click Bar Chart in the transfer Visualization group.
  • Click Stacked Bar.

Exploring Data with Power View Charts

The table Visualization on the right gets converted to Bar Chart Visualization. As you observe, the y-axis values are sorted by way of the category values in ascending order.

Exploring Data with Power View Charts

  • Take the cursor above the Bar chart. you will locate – sort through NOC_CountryRegion asc.
  • Click NOC_CountryRegion. it is changed to Medal count.
  • Click asc. it is changed to desc. you will locate that the Bar Chart is sorted by descending Medal count.

Exploring Data with Power View Charts

  • Click the Bar with class GER. only that Bar may be highlighted.
  • With Ctrl key pressed, click on the Bars with categories FRA and ITA. The Bars for GER, FRA and ITA can be highlighted.
  • The table on the left also indicates values for these 3 categories only.

Exploring Data with Power View Charts

In both the visualizations, click the Gender field also in the Power View Fields list.

Exploring Data with Power View Charts

Click the left part of the Bar – GER. it is highlighted. in the table, only the data for GER and men can be displayed.

Note − You cannot make multiple choices in this example.

Exploring Data with Power View Charts

Exploring with Column Charts

You may use Column charts for showing data changes over a period of time or for illustrating comparison among gadgets. In Column charts, classes are along the horizontal axis and values along the vertical axis.

In power View, there are three Column chart subtypes −

  • Stacked Column.
  • 100% Stacked Column.
  • Clustered Column.

You may convert a table Visualization to Column Chart Visualization as follows −

  • Create table visualizations side-by-side.
  • Click on the right table.
  • Click on Column Chart within the transfer Visualization group.
  • Click Stacked Column.

Exploring Data with Power View Charts

The table Visualization on the right is transformed to Bar Chart Visualization. As you observe, the x-axis values are sorted by using the class values in ascending order.

Exploring Data with Power View Charts

  • Take the cursor to above the Column chart. you may locate – sort through NOC_CountryRegion asc.
  • Click on on NOC_CountryRegion. It receives changed to Medal count.
  • Click on on asc. It receives changed to desc. you will locate that the Column Chart is sorted by descending Medal count.

Exploring Data with Power View Charts

Click on the lower portion of the Bar with Category GER. It gets highlighted.

In the Table, only the information for GER and Men will be displayed.

Exploring Data with Power View Charts

Exploring with Easy Pie Charts

Pie charts in power View are easy or sophisticated. you may analyze simple Pie charts in this section. you will study sophisticated Pie charts in the next phase.
Start with creating a Pie chart as follows −

  • Resize the Stacked Column chart and move it upwards.
  • Create any other table visualization below the Stacked Column chart.
  • Click the new table.
  • Click other Chart in the switch Visualization group.
  • Select Pie.

Exploring Data with Power View Charts

The table Visualization under the Stacked Column chart is converted to Pie Chart Visualization. As you study, there are too many slices in the Pie chart as there are many classes (countries). note that Pie charts work well only when the number of classes is 8 or less.

Exploring Data with Power View Charts

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

  • Set the filtering as Medal count is extra than or same to 1300 in −
    • Table Visualization
    • Column Chart Visualization
    • Pie Chart Visualization

Note − you have to define and follow filtering to each of the visualizations separately.

Exploring Data with Power View Charts

Now, you have a easy Pie Chart Visualization, in which the count of Medals are shown through the Pie size, and countries through colors.
Click on on a Pie slice. That slice is highlighted and others get grayed. The corresponding column in the Column chart also is highlighted. in the table, only the values similar to the highlighted Pie slice can be displayed.

Exploring Data with Power View Charts

Exploring with Sophisticated Pie Charts

You can make your Pie Chart Visualization sophisticated, via adding extra features. you can make a pie char that −

  • Drills down when you double-click a slice, or
  • Indicates sub-slices in the large color slices.

A Pie chart that drills down when you double-click a slice

  • In the Pie chart, in the power View Fields list, drag the field Gender to color area, to under the field NOC_CountryRegion. this means you have two categories.

  • In the table, consist of Gender also in the Fields list.

Your power View looks as follows –

Exploring Data with Power View Charts


As you observe, there is a single slice with one color for each category - country.
At the Pie chart, double-click on the usa slice.

The Pie chart to your power View may be modified to show values via Gender, which is the second category, for the chosen category (usa). the colors of the pie chart now display the percentages of the second field, i.e., Gender, filtered for the pie color you double clicked. In other words, the Pie chart was drilled down. As you observe, a small arrow seems on the top right corner of the Pie chart. if you place the mouse over it, the arrow is highlighted and Drill up can be displayed.

Exploring Data with Power View Charts

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

A Pie chart that shows sub-slices within the larger color slices

In the Pie chart, in the power View Fields list, drag the field Gender from color area to SLICES region.

Your power View seems as follows –

Exploring Data with Power View Charts

As you can see, inside the Pie chart, there are two slices of same color for the class usa.

Click on one of these slices.

You may be able to see the following changes in power View −

  • The selected slice is highlighted and other slices are grayed or deactivated.
  • The bar for the class usa shows the medal depend for the selected slice.
  • The table indicates the values for the selected slice.

Exploring Data with Power View Charts

  • Click the other slice. You can observe the changes as given above for this selected slice.

Exploring Data with Power View Charts

Exploring with Scatter Charts

You may use Scatter charts to show many related data in one chart. In Scatter charts, the x-axis shows one numeric field and the y-axis shows another, making it easy to see the relationship among the two values for all the objects in the chart.

To create a Scatter Chart Visualization, continue as follows −

  • Upload the fields sport, Medal count and event to table.
  • Click on the arrow next to event inside the power View Fields list. click on rely (distinct). the field event changes to the numeric field count of event. therefore, you have one category field – sport and two numeric fields – Medal count and count of event.
  • Click on other Chart in the switch Visualization group.
  • Click Scatter.

Exploring Data with Power View Charts

You will get the Scatter Chart Visualization, with the data points displayed as circles of same size, showing how the be counted of event and Medal count values are related for every sport.

Exploring Data with Power View Charts

  • Click the LAYOUT tab on the Ribbon.
  • Click Data Labels in the Labels group.
  • Select Right from the drop-down list. The Data labels appear for the data points.

Exploring Data with Power View Charts

The sport Wrestling has less variety of medals in more number of events as compared to the sport Aquatics that has extra number of medals in less number of events.

Exploring with Bubble Charts

You can use Bubble charts to show many related data in a single chart. In Bubble Charts, the x-axis shows one numeric area and the y-axis shows any other, making it easy to see the relationship between the two values for all the items within the chart. a third numeric field controls the size of the data points.

To create a Bubble Chart Visualization, proceed as follows −

  • Drag Medal count to size.
  • Drag NOC_CountryRegion to ∑ X-value. The Scatter chart is converted to Bubble chart.

Exploring Data with Power View Charts

As you observe, the size of each bubble shows the medal count. The data labels show the Sport.

Exploring with Colors

You can also color the bubbles by a category as follows −

  • Drag the field NOC_CountryRegion to COLOR area in the Power View Fields list.
  • Drag the field DiscipleEvent to ∑ X-VALUES.

Exploring Data with Power View Charts

As you observe, Legend indicates the values of the category this is in color area and the respective colors. The data labels correspond to the category in info area. the size of the data points is by the area ∑ size.

Next, you can see how choosing a category in Legend changes the visualization −

Click on on a value in the Legend. only the data factors of that color (i.e., similar to that value) will be highlighted. all the other data points will be deactivated.

Exploring Data with Power View Charts

As you study, all the sports similar to the selected country are displayed and the size of each bubble represents the medal count.

If you need to recognize the info of a single data point −

  • Highlight the data point by just clicking on that bubble.
  • Place the cursor on that data point.

Best that bubble is highlighted and the rest of the bubbles get grayed. all of the information about that data point can be displayed in a box next to the data point.

Exploring Data with Power View Charts

Exploring with Play Axis

You may visualize the data changes over a period of time using Play Axis as follows −

  • Drag the field version in the power View Fields list to PLAY AXIS place.

A timeline with a Play button is inserted to your Bubble chart visualization. you can adjust the timeline by filtering the version field values within the Filters. this will be useful if you need to focus on a selected time range or if the timeline is too extensive.

  • Adjust the timeline by way of filtering version field in Filters and selecting a span of time values.

Exploring Data with Power View Charts

  • Click on the Play button. The bubbles travel, grows and shrink to reveal how the values change based on the play axis. A small vertical line seems on the timeline that moves across the timeline. The time at that point also is displayed.

Exploring Data with Power View Charts

You can pause at any point to study the data in more detail.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Excel Data Analysis Topics