Version 3: 10/29/2012
Purpose:
Purpose of this document is to provide a “quick reference” of visualization options available in each tool. Many other variations are available by changing properties (particularly in SSRS), and due to sheer volume those various property combinations aren’t covered in this document.
Applicable Software Versions:
PerformancePoint Services – SharePoint Enterprise 2013 SharePoint Server – SharePoint Enterprise 2013
SQL Server Reporting Services – SQL Server 2012 Excel – Microsoft Office Professional Plus 2013 Power View – Office 2013 and SharePoint 2013
Contents:
Charts Data Bars Indicators Tabular Scorecards Gauges Sparklines Maps Miscellaneous
Charts:
Type of Chart
Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel
Power View Column
Classic 2- dimensional chart with x and y values.
Useful for comparing values across categories.
Bar Chart Column Clustered
Column
Clustered Column
Chart Services Server Services Excel View
3D Column ---
3D Column
3D Clustered
Column
3-D Column
3-D Clustered
Column
---
Stacked Column Displays the relationship of each value to the whole.
Stacked Bar
Chart Stacked
Column Stacked Column
Stacked Column
3D Stacked Column
---
3D Stacked
Column Stacked Column in
3-D
---
Chart Services Server Services Excel View 100%
Stacked Column Cumulative proportion of each stacked element equals 100%
100%
Stacked Bar Chart
100%
Stacked Column
100%
Stacked Column
100%
Stacked Column
3D 100%
Stacked Column
---
3D 100%
Stacked Column
100%
Stacked Column in
3-D
---
3D Cylinder ---
3D Cylinder
3D Clustered
Cylinder
3-D Cylinder
Clustered Cylinder
---
3D Stacked Cylinder
--- ---
3D Stacked
Cylinder Stacked Cylinder
---
3D 100%
Stacked Cylinder
--- ---
3D 100%
Stacked Cylinder
100%
Stacked Cylinder
---
Cone --- --- ---
Clustered Cone
3-D Cone
---
Chart Services Server Services Excel View Stacked
Cone
--- --- ---
Stacked Cone
---
100%
Stacked Cone
--- --- ---
100%
Stacked Cone
---
Bar Same as Column Chart (aka Vertical Bar Chart);
rotated 90 degrees
---
Bar Clustered Bar
Clustered Bar
Chart Services Server Services Excel View
3D Bar ---
3D Clustered
Bar
Clustered Bar in 3-D
---
Stacked Bar ---
Stacked Bar Stacked Bar Stacked Bar
3D Stacked Bar
---
3D Stacked Bar
Stacked Bar in 3-D
---
100%
Stacked Bar
---
100%
Stacked Bar
100%
Stacked Bar
100%
Stacked Bar
Chart Services Server Services Excel View 3D 100%
Stacked Bar
---
3D 100%
Stacked Bar 100%
Stacked Bar in 3-D
---
Horizontal Cylinder
---
3D Clustered Horizontal
Cylinder
Clustered Horizontal
Cylinder
---
Stacked Horizontal Cylinder
--- ---
3D Stacked Horizontal Cylinder
Stacked Horizontal
Cylinder
---
100%
Stacked Horizontal Cylinder
--- ---
3D 100%
Stacked Horizontal
Cylinder
100%
Stacked Horizontal
Cylinder
---
Horizontal Cone
--- --- ---
Clustered Horizontal
Cone
---
Stacked Horizontal Cone
--- --- ---
Stacked Horizontal
Cone
---
100%
Stacked Horizontal Cone
--- --- ---
100%
Stacked
---
Chart Services Server Services Excel View Area
Same as a Line Chart;
with fill color behind to emphasize the degree of change over time
---
Area Area
---
3D Area ---
3D Area 3-D Area
---
Smooth Area
---
Smooth Area
--- ---
3D Smooth Area
---
3D Smooth Area
--- ---
Chart Services Server Services Excel View Stacked
Area
---
Stacked
Area Stacked
Area
---
3D Stacked Area
---
3D Stacked
Area Stacked
Area in 3-D
---
100%
Stacked Area
---
100%
Stacked Area
100%
Stacked Area
---
3D 100%
Stacked Area
---
3D 100%
Stacked Area
100%
Stacked Area in 3-D
---
Line Displays trends in the data;
suitable for displaying changes over time
Line Chart
Line Chart with Markers
Line
Line with Markers
Line
Line with Markers
Line
Chart Services Server Services Excel View
3D Line ---
3D Line 3-D Line
---
Stacked Line --- --- ---
Stacked Line
Stacked Line with
Markers
---
100%
Stacked Line
--- --- ---
100%
Stacked Line
100%
Stacked Line with
Markers
---
Chart Services Server Services Excel View Smooth Line ---
Smooth Line
Smooth Line with
Markers
--- ---
3D Smooth Line
--- --- --- ---
Step Line ---
Stepped Line
--- ---
3D Step Line --- --- --- ---
Chart Services Server Services Excel View XY Scatter
(Point) Density &
placement of points indicate relationships (or lack thereof) between a pair of values
---
Scatter Scatter with Only Markers
Scatter with Smooth Lines and
Markers
Scatter with Smooth
Lines
Scatter with Straight Lines and
Markers
Scatter with Straight
Lines
Scatter
3D XY Scatter (Point)
--- --- --- ---
Chart Services Server Services Excel View Bubble
A type of XY Chart – a Bubble has 3 values. The size of the bubble represents the 3rd data value not shown on X or Y axis; the larger the 3rd data value, the larger the bubble.
---
Bubble Bubble
If a 3rd measure is added, turns into a bubble
chart
3D Bubble ---
3D Bubble Bubble with a 3-D Effect
---
Chart Services Server Services Excel View Stock
Most typically used for stock price data to show the high price, low price, and close price.
---
Stock High-Low- Close
---
3D Stock --- --- --- ---
Chart Services Server Services Excel View
Candlestick ---
Candlestick
Open-High- Low-Close
---
3D
Candlestick
--- --- --- ---
Price Volume
--- ---
Volume- High-Low-
Close
Volume- Open-High-
Low-Close
---
Chart Services Server Services Excel View Pie
Compares proportion % of overall total value;
works best with a single series &
value.
Pie Chart Pie
Exploded Pie
Pie
Exploded Pie
Pie of Pie
Bar of Pie
Pie
3D Pie ---
3D Pie
3D Exploded
Pie
Pie in 3-D
Exploded Pie in 3-D
---
Doughnut Compares proportion % of overall total value;
unlike a Pie Chart, a doughnut can contain more than one data series.
---
Doughnut
Exploded Doughnut
Doughnut
Exploded Doughnut
---
Chart Services Server Services Excel View 3D
Doughnut
--- --- --- ---
Radar Displays changes in values relative to a center point;
suitable for finding outliers or commonality
---
Radar
3D Radar
Radar
Radar with Markers
Filled Radar
---
Chart Services Server Services Excel View
Polar ---
Polar
--- ---
Chart Services Server Services Excel View Surface
Displays trends across two dimensions in a
continuous curve
--- --- ---
3-D Surface
Wireframe 3-D Surface
Contour
Wireframe Contour
---
Range Bar --- ---
Range Bar
---
Gantt Displays separate beginning and end values; often plotted along time to plan the use of resources
--- ---
(A close substitute:
using the Range Bar or Stacked Bar)
---
(A close substitute:
using a Stacked Bar)
---
Chart Services Server Services Excel View
3D Gantt --- ---
(A close substitute:
using the 3D Stacked Bar)
--- ---
Range Column
---
Range Column
--- ---
Chart Services Server Services Excel View 3D Range
Column
--- --- --- ---
Range Compares variations versus a control by plotting 2 Y-values per data point, each being drawn as a line chart.
The range between values is filled with color.
---
Range
--- ---
Smooth Range
---
Smooth Range
--- ---
Chart Services Server Services Excel View
3D Range --- --- --- ---
3D Smooth Range
--- --- --- ---
Error Bar Displays statistical info about the data displayed in another series;
---
Error Bar
--- ---
Chart Services Server Services Excel View contains 3
Y-values
3D Error Bar --- --- --- ---
Chart Services Server Services Excel View
Box Plot Summarize the
distribution of data
---
Box Plot
--- ---
Chart Services Server Services Excel View
3D Box Plot --- --- --- ---
Chart Services Server Services Excel View
Funnel Compares proportion % of overall value; works best with a single series
& value.
---
Funnel
--- ---
Chart Services Server Services Excel View
3D Funnel ---
3D Funnel
--- ---
Chart Services Server Services Excel View Pyramid
Compares proportion % of overall value; works best with a single series
& value.
---
Pyramid Clustered Pyramid
---
Chart Services Server Services Excel View
3D Pyramid ---
3D Pyramid 3-D Pyramid
---
Chart Services Server Services Excel View 100%
Stacked Pyramid
--- --- ---
100%
Stacked Pyramid
---
Horizontal Pyramid
--- --- ---
Clustered Horizontal
Pyramid
---
Stacked Horizontal Pyramid
--- --- ---
Stacked Horizontal
Pyramid
---
100%
Stacked Horizontal Pyramid
--- --- ---
100%
Stacked Horizontal
Pyramid
---
Gauges:
Type of Gauge
Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel Power View Radial
Circular format;
indicator pivots around scale to display value
compared to goal.
---
Radial
Radial with Mini Gauge
Two Scales
90 Degrees
--- ---
Type of Gauge Services Server Services Excel Power View NE
90 Degrees NW
90 Degrees SW
90 Degrees SE
180 Degrees North
180 Degrees South
180 Degrees West
180 Degrees East
Meter
Type of Gauge Services Server Services Excel Power View Linear
Rectangular or
“thermometer”
type format displays value compared to goal.
Progress Bars
---
Horizontal
Vertical
Multiple Bar Pointers
Two Scales
Three Color Range
Logarithmic
Thermometer
Thermometer Fahrenheit /
Celcius
Bullet Graph
--- ---
Data Bars:
Type of Data Bar
Performance Point
Services SharePoint Server
SQL Server Reporting
Services Excel Power View
Data Bar In-line with text; useful for
comparing values (similar to bar chart)
--- ---
Bar
Stacked Bar
100%
Stacked Bar
---
Data Column
--- ---
Column
Stacked Column
100%
Stacked Column
--- ---
Type of Sparkline
Point Services
SharePoint Server
Reporting
Services Excel Power View Column
Sparkline In-line with text; useful for
displaying trends (similar to line chart)
--- ---
Column
Stacked Column
100%
Stacked Column
---
Line Sparkline
--- ---
Line
Line with Markers
Smooth Line
Smooth Line with Markers
Stepped Line
---
Sparkline Services Server Services Excel Power View Area
Sparkline
--- ---
Area
Smooth Area
Stacked Area
100%
Stacked Area
--- ---
Shape Sparkline
--- ---
Pie
Exploded Pie
3D Pie
3D Exploded Pie
Doughnut
--- ---
Sparkline Services Server Services Excel Power View Range
Sparkline
--- ---
Stock
Candlestick
Error Bar
Box Plot
--- ---
Indicators:
Type of Indicator
Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel
Power View Shapes
Displays the state or condition of a value
Symbols
Indicator Services Server Services Excel View Directional
(Trend)
--- ---
Ratings ---
Other --- --- --- ---
Maps:
Type of Map
Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel
Power View Geographical
map Spatial
representation of a
geographic area and its characteristics (including terrain)
--- ---
Alternatives: can use a 3rd party tool
Basic Map
---
Alternatives: can use Microsoft MapPoint, or a 3rd
party tool
Custom approach:
a map image (background) with the coordinates plotted using an XY Scatter chart, or objects placed on top of the
image
Map Integrated
with Bing Maps
Color Analytical Map
--- ---
Color Analytical Map
--- ---
Bubble Map --- ---
Bubble Map
--- ---
Tabular:
Type of Tabular Layout
Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel
Power View Table
Grid
Tablix (Table) Pivot
Table
Table
Matrix
(Crosstab) Grid
--- Tablix (Matrix) Pivot
Table
Matrix
Type Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel
Power View Bullet Graph
(popularized by Stephen Few)
--- ---
Bullet Graph
---
Although not built in, it can be done by an advanced Excel
user. See Link 1
& Link 2
---
Decomposition Tree
Displays how individual members contribute to the total
Only available during user interaction from another PPS view already published
--- --- --- ---
Heat Map --- --- Built In:
SQL Server Spatial Query (requires
“geometry” data in the data source) Or:
Use of expressions or custom coding to set backcolor and/or sizing
Color Scales
(Will provide backcolor but not sizing of area based on
value)
---
Strategy Map Integrated with Visio
Services --- --- --- ---
Card
Displays data much like an index card;
often contains an image
--- --- --- ---
Card
Type
Performance Point Services
SharePoint Server
SQL Server Reporting
Services Excel
Power View
Scorecard ---
Custom approach:
use Table &
Indicators
---
Custom approach:
use tabular layout and conditional formatting
---
Dashboard
Web Part Page
---
Custom approach:
use multiple data regions in same
report
---
Custom approach:
use multiple pivot table grids
& charts on same worksheet
Silverlight Page
(no zones or specific layout)
Type Services Server Services Excel View
