Excel Power View - Chart Visualizations


Advertisements


In Power View, you have a number of Chart options. The Charts in Power View are interactive. Further, the Charts are interactive in a presentation setting also, which would enable you to highlight the analysis results interactively.

In this chapter, you will have an overview of the Chart visualizations. You will learn them in detail in the subsequent chapters.

Types of Chart Visualizations

In Power View, you have the following types of Chart visualizations −

  • Line
  • Bar
  • Column
  • Scatter
  • Bubble
  • Pie

Line, Bar and Column Charts

You can use Line, Bar and Column charts for comparing data points in one or more data series.

Line Chart

In a Line Chart, categories are along the horizontal axis and values along the vertical axis.

Line Chart

Bar Chart

In a Bar Chart, categories are along the vertical axis and values along the horizontal axis.

Bar Chart

Column Chart

In a Column Chart, categories are along the horizontal axis and values along the vertical axis.

Column Chart

Scatter and Bubble Charts

You can use Scatter Charts and Bubble Charts to display many related data in one Chart. In Scatter Charts and Bubble Charts, the x-axis displays one numeric field and the y-axis displays another. In Bubble Charts, a third numeric field controls the size of the data points.

Scatter Chart − A scatter chart is shown below −

Scatter Chart

Bubble Chart − A bubble chart is shown below −

Bubble Chart

Pie Charts

In a Pie Chart, the numeric field can be shown by the Pie slice size, and categories by colors.

In Power View, Pie Charts can be simple or sophisticated. In a sophisticated Pie Chart, you can have the following additional features −

  • Drill down when you double-click a Pie slice.
  • Show sub-slices within the larger Pie slices.

Pie Chart − A Pie chart is shown below −

Pie Chart

Interactive Nature of Chart Visualizations

The Charts in Power View are interactive. If you click on a value in one Chart −

  • That value in that Chart is highlighted.
  • That value in all the other Charts in Power View is also highlighted.
  • All the Tables, Matrices and Tiles in Power View are filtered to that value.
Nature of Chart

You will learn more about this and other additional interactive features such as Play Axis, Colors, and Tiles in subsequent chapters.



Advertisements
E-Books Store