Chart Types

Question 1

Bar Chart

Answer 1

Provides a quick visual comparison of related values

Types: Bar, Column, Stacked Bar, Stacked Column

Stacked Bar/Column shows groups within each bar

Question 2

Calendar Heat Map Chart

Answer 2

Visualizes recurring discrete activities, such as closing accounts, over a long period of time

You can easily change the granularity of the time-based grouping, such as from month to week or day

Question 3

Column Chart

Answer 3

Shows relative counts of things

AKA “vertical bar chart”

Stacked Column shows groups within each bar

Question 4

Combo Chart

Answer 4

Displays at least 2 related series of data, such as a bar chart overlaid with a line chart showing the average value

Question 5

Donut Chart

Answer 5

Shows the proportion of each member against the total, with the total in the center

You can remove the center by selecting 0% from the Center Size menu – this changes it to a pie chart

Question 6

Dot Plot Chart

Answer 6

Uses size and coloring of bubbles to display multiple dimensions and members

Can be horizontal or vertical

Use to compare performance or locate outliers

Question 7

Funnel Chart

Answer 7

Visualizes sequential data that can be broken up into stages, like a sales cycle

Question 8

Gauge Chart

Answer 8

Tracks progress along a single measure

Ex: current revenue against the target

Question 9

Bullet Chart

Answer 9

Compares metrics against quantitative benchmarks and references

Ex: current revenue with target revenue

Question 10

Heat Map

Answer 10

Visually enhances high and low value data when there’s a single measure and multiple dimensions

Similar to matrix, but uses color and not size

Question 11

Line Chart

Answer 11

Useful for showing data over time

Use when you have one important grouping representing (time or other type of dimension) and one value

Question 12

Map Chart

Answer 12

Use with geographical data

Can shade areas in proportion to mapped values

Question 13

Bubble Map Chart

Answer 13

Visually indicates measure values in specified geographical areas

Question 14

Geo Map Chart

Answer 14

Allows you to visualize data that contains geographical coordinates

Coordinates let you place visual data elementse more precisely

Question 15

Custom Map Chart

Answer 15

Create a custom map if you have data with a geographical component that doesn’t match any of the standard maps

Ex: custom regions

Ex: areas that can be represented with polygons, like stadium seat sections, city blocks, or floor plans

Question 16

Matrix Chart

Answer 16

A table that uses dot size and color so you can quickly spot extreme values

Ex: products for all customers, see which products are the most popular

Question 17

Origami Chart

Answer 17

Creates a striking horizontal visualization to easily identify high and low value data when there’s a single measure and a single dimension

Like a horizontal “heat map” but with only one row, using both size and color

Question 18

Parallel Coordinates Chart

Answer 18

Displays how data elements in a dimension stack up against each other

Use when you have multiple measures and a single dimension

Question 19

Pyramid Chart

Answer 19

Visually highlights relative sizes of stacked dimension values

2 vertical bar charts, one on either side

Question 20

Radar Chart

Answer 20

Displays a small dataset with one dimension and at least 3 measure columns

Visually represents a dimension along 3 or more measure axes that have different scales

Question 21

Ratings Chart

Answer 21

Displays how well a measured quality, like customer satisfaction, is meeting expectations

Shows how close you are to a goal

Looks like the star rating system on Yelp

Question 22

Sankey Chart

Answer 22

Visualizes the distribution of a measure from one dimension to another

Performs calculations based on the absolute value of each measure

Doesn’t support scroll and doesn’t render when there’s not enough space

Question 23

Scatter Chart

Answer 23

Visualizes correlation between two groups of data

2 measures, one on each axis, with colors and size

Ex: analyze the correlation between total opportunity amount and number of opportunities for product families

Question 24

Timeline Chart

Answer 24

Column chart with the horizontal axis showing a time dimension

Visualizes changes over time with vertical bars

Illustrates relative changes over time and highlights missing data

Question 25

Time Combo Chart

Answer 25

Shows two or more measures over time; each measure can be a line or a bar

If using multiple bars, you can stack them to compare parts of the whole

They can be on the same or separate axes

Question 26

Treemap Chart

Answer 26

Visualizes hierarchical quantitative data

Containing rectangles designate relationship using color

Leaf rectangles represent quantity using area

Question 27

Waterfall Chart

Answer 27

Shows a running total as values are added or subtracted

Useful for understanding how an initial value is affected by a series of positive and negative values

AKA flying bricks or Mario charts

Stacked waterfall chart includes breakdowns of value totals