Scribd
Upload
24 views2 pages

Chart Decision Guide Table

The document is a guide for selecting the appropriate chart type for data analysis in Tableau or Excel, categorized by analytical intent such as trend, comparison, composition, distribution, relationship, and hierarchy. Each category includes keywords, recommended chart types, usage scenarios, and example questions to guide users in their data visualization choices. This resource serves as a quick reference to enhance data presentation and interpretation.

Uploaded by

Suraj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
24 views2 pages

Chart Decision Guide Table

The document is a guide for selecting the appropriate chart type for data analysis in Tableau or Excel, categorized by analytical intent such as trend, comparison, composition, distribution, relationship, and hierarchy. Each category includes keywords, recommended chart types, usage scenarios, and example questions to guide users in their data visualization choices. This resource serves as a quick reference to enhance data presentation and interpretation.

Uploaded by

Suraj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

📊 Chart Decision Map: A Guide to

Choosing the Right Chart


Refer to this chart-type guide whenever you analyze data in Tableau or Excel.

Analytical Keyword Best Chart When to Use Example


Intent Triggers Type(s) Questions
Trend / Change "trend", Line Chart, You want to • How has
Over Time "monthly", Area Chart track values or traffic evolved
"yearly", totals changing month-by-
"seasonal", over time month?
"growth", "over • What’s the
time", trend in sales
"evolution" over the year?
Comparison "compare", Clustered You want to • How do
(Side-by-Side) "versus", Column Chart, compare values regions
"difference", Bar Chart across compare in
"across", "top", categories sales?
"bottom", clearly • Which branch
"high/low" has the highest
profit?
Composition "composition", Pie Chart, You want to • What’s the
(Parts of a "breakdown", Stacked Bar show how expense
Whole) "contribution", Chart, Tree Map categories breakdown per
"share", contribute to a department?
"proportion", total • What % of
"percentage" sales is from
each product?
Composition "growth by Area Chart, You want to • How has each
Over Time part", Stacked Bar show how department’s
"contribution Chart different cost grown
over time", components month-by-
"cumulative" build the total month?
over time • What’s the
monthly share
of revenue by
source?
Distribution "spread", Histogram, Box You want to see • What’s the
(Spread / "distribution", Plot how values are distribution of
Frequency) "range", spread (e.g., delivery times?
"frequency" scores, prices) • How do
salaries vary
across teams?
Relationship / "relationship", Bubble Chart, You want to • How does
Correlation "impact", Scatter Plot show how 2+ marketing
"interaction", numerical spend relate to
"correlation", variables relate reach and
"affect" engagement?
• What’s the
link between
profit and
customer
rating?
Hierarchy "hierarchy", Tree Map You want to • How is the
(Nested "nested", show parts budget split by
Composition) "levels", "sub- within parts department
category" and sub-
department?
• What’s the
contribution of
cities within
states?

You might also like