Excel Power View Tutorial
Excel Power View Useful Resources
Selected Reading
- Sharing
- Formatting a Report
- Key Performance Indicators
- Hierarchies
- Excel Power View and Data Model
- Advanced Features
- Tiles Visualizations
- Multiple Visualizations
- Map Visualization
- Pie Chart Visualization
- Scatter & Bubble Chart Visualization
- Column Chart Visualization
- Bar Chart Visualization
- Line Chart Visualization
- Chart Visualizations
- Card Visualization
- Matrix Visualization
- Table Visualization
- Visualizations
- Sheet
- Creation
- Overview
- Excel Power View - Home
Excel Power View Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Chart Visualizations
Excel Power View - Chart Visuapzations
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 highpght the analysis results interactively.
In this chapter, you will have an overview of the Chart visuapzations. You will learn them in detail in the subsequent chapters.
Types of Chart Visuapzations
In Power View, you have the following types of Chart visuapzations −
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.
Bar Chart
In a Bar Chart, categories are along the vertical axis and values along the horizontal axis.
Column Chart
In a Column Chart, categories are along the horizontal axis and values along the vertical axis.
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 −
Bubble Chart − A bubble chart is shown below −
Pie Charts
In a Pie Chart, the numeric field can be shown by the Pie spce 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-cpck a Pie spce.
Show sub-spces within the larger Pie spces.
Pie Chart − A Pie chart is shown below −
Interactive Nature of Chart Visuapzations
The Charts in Power View are interactive. If you cpck on a value in one Chart −
That value in that Chart is highpghted.
That value in all the other Charts in Power View is also highpghted.
All the Tables, Matrices and Tiles in Power View are filtered to that value.
You will learn more about this and other additional interactive features such as Play Axis, Colors, and Tiles in subsequent chapters.
Advertisements