Tableau Quiz: Choosing Chart Types

10 questions · exam conditions

0:00

Choosing Chart TypesQuestion 1 of 10

A retailer tracks weekly sales for three regions. One region consistently sells about ten times more than another. Management wants to determine whether the regions experience increases and decreases during the same weeks and to compare each region's relative change from its own starting level. Absolute sales differences are secondary.

Which visualization best addresses management's question?

A stacked area chart using weekly sales, with one colored area for each region

An indexed line chart setting each region's first-week value to the same baseline

A side-by-side bar chart showing absolute weekly sales for all three regions

A dual-axis line chart placing the largest region on a separate sales axis

← Back to quizzes

Tableau Quiz

Tableau Quiz: Choosing Chart Types

Practice Choosing Chart Types in Tableau with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Choosing Chart Types, giving you a quick way to practice the rules, question types, and explanations that matter most for Tableau.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

Which visualization best addresses management's question?

A stacked area chart using weekly sales, with one colored area for each region
An indexed line chart setting each region's first-week value to the same baseline (correct answer)
A side-by-side bar chart showing absolute weekly sales for all three regions
A dual-axis line chart placing the largest region on a separate sales axis

Explanation: When a question asks you to compare relative movement across groups with very different magnitudes, your instinct should shift away from absolute values and toward normalization techniques. The core challenge here is that one region sells roughly ten times more than another — meaning raw sales numbers will visually dwarf the smaller regions, making pattern comparison nearly impossible. An indexed line chart (B) solves this by resetting every region's first-week value to the same baseline — typically 100. From that point, each line shows percentage change relative to its own starting point, not absolute dollars. This lets you immediately see whether regions rise and fall together and how dramatically each one moves relative to itself. That's precisely what management wants. Choice A, the stacked area chart, displays cumulative totals over time. The dominant region's area will visually overwhelm the smaller ones, and stacking makes it impossible to isolate individual trends — the exact problem you're trying to avoid. Choice C, side-by-side bars, shows absolute weekly sales. The ten-times scale difference means the smaller region's bars are barely visible next to the largest region's bars, defeating any useful comparison of relative change. Choice D, a dual-axis chart, is a tempting distractor because it does address scale differences. However, dual-axis charts are designed for comparing two series with different units or scales — and they only support two axes, which becomes unwieldy with three regions. More importantly, they still display absolute values, not relative change from a common baseline. Your study tip: whenever you see "relative change," "compared to its own starting level," or wildly different magnitudes in the same dataset, indexed charts are almost always the right tool.

Question 2

An analyst must compare delivery-time distributions across eight warehouses. The audience needs to see medians, differences in spread, skewed results, and unusually slow deliveries. The number of shipments varies substantially by warehouse.

Which chart should the analyst choose as the primary view?

A box-and-whisker plot with one distribution for each warehouse (correct answer)
A bar chart showing the average delivery time for each warehouse
A line chart connecting warehouse median delivery times in alphabetical order
A packed-bubble chart sizing warehouses by their total number of shipments

Explanation: When a question asks you to compare distributions across multiple groups — especially when the goal is to surface medians, spread, skew, and outliers simultaneously — your first instinct should be to reach for a chart that displays the full shape of the data, not just a single summary statistic. A box-and-whisker plot does exactly this. Each box shows the median (center line), the interquartile range (the box itself representing the middle 50% of values), and whiskers that extend to show overall spread, with outlier points plotted individually beyond them. One box per warehouse lets your audience compare all eight warehouses on every dimension the question requires: medians, spread, skew (visible when the median sits off-center in the box), and unusually slow deliveries (outlier dots). The variation in shipment counts across warehouses is a distraction — box plots are robust to unequal group sizes because they display proportional statistics rather than raw totals. Answer A is the right choice. Answer B falls short because an average is a single number. It hides skew and outliers entirely — a warehouse with a few catastrophically late shipments might look fine on average. Answer C connects medians with a line, implying a trend or progression across warehouses sorted alphabetically, which is meaningless and misleading. Lines encode sequence or change over time, not categorical comparisons. Answer D sizes bubbles by shipment volume, which tells you how busy each warehouse is, not anything about delivery-time distribution — it completely ignores the question's core requirements. A useful rule of thumb: whenever you see "distribution," "spread," "skew," or "outliers" in the requirements, box plots are almost always the correct answer on the Tableau exam.

Question 3

A company sells twelve product categories. An executive wants to compare how each category's share of total revenue changed between two years. Differences in total revenue between the years are intentionally out of scope, and precise category-by-category comparisons matter more than emphasizing the overall composition.

Which chart best supports this analysis?

Two pie charts, one for each year, with identical category colors
A one-hundred-percent stacked bar for each year, segmented by product category
Grouped bars by product category, showing each year's percent of total revenue (correct answer)
A treemap for each year, sizing category rectangles by percent of total revenue

Explanation: When a question asks you to compare how individual parts of a whole changed between periods, you need to separate two distinct goals: showing composition versus enabling precise comparison. That distinction is what this question is testing. The scenario emphasizes "precise category-by-category comparisons" across two years while deliberately setting aside total revenue differences. That framing points directly to C — grouped bars by product category, each showing percent of total revenue for both years. With grouped bars, every category gets two bars side by side, making it trivially easy to read the exact value for each year and judge the difference. Your eye can directly compare bar heights within a group. Each wrong answer fails in a specific way. A — side-by-side pie charts — is a classic trap. Humans are notoriously poor at judging angular differences between slices, especially across two separate charts. With twelve categories, the slices become tiny and comparisons become unreliable. B — a 100% stacked bar — is better than pies but still struggles with the same problem: only the bottom segment has a stable baseline (zero), so every other segment floats, making precise comparison difficult for interior categories. D — treemaps — are excellent for showing relative size within a single snapshot but are among the hardest chart types for detecting change between periods, since comparing rectangle areas across two separate treemaps is imprecise and cognitively demanding. A useful rule of thumb: whenever change over time and precise comparison are both priorities, reach for a bar or line chart. Pie charts, treemaps, and stacked bars optimize for composition at a glance — not for analytical precision.

Question 4

A project manager has task names, planned start dates, and planned end dates for a software release. The manager needs to identify task duration, overlapping work, and gaps in the schedule. Completion percentage is available but is not the primary analytical question.

Which visualization most directly answers the manager's question?

A Gantt chart positioning each task by start date and extending it through its duration (correct answer)
A line chart plotting cumulative completed tasks for each day of the project
A calendar heat map coloring each date by the number of active tasks
A stacked bar chart dividing each task into completed and remaining percentages

Explanation: When a question asks which chart "most directly" answers a specific analytical need, your job is to match the chart type to the exact questions being asked — here, task duration, overlapping work, and schedule gaps. That's the classic use case for one specific chart type. A Gantt chart, choice A, is purpose-built for exactly this scenario. Each task is plotted as a horizontal bar beginning at its start date and extending through its end date, making duration visually obvious. When bars overlap vertically, you can immediately see concurrent tasks. Empty horizontal space between bars reveals schedule gaps. No calculations or interpretive leaps required — the answers are right there in the shape of the chart. The wrong answers each address something related but different. Choice B, a line chart of cumulative completed tasks, shows overall project velocity and momentum but tells you nothing about individual task timing or overlap — you can't see when specific tasks start, end, or collide. Choice C, a calendar heat map, shows which days are busiest by coloring dates according to active task count, which hints at overlap but obscures individual task identity, duration, and gap structure entirely. Choice D, a stacked bar showing completed versus remaining percentages, directly visualizes completion progress — which the passage explicitly tells you is not the primary question. This is a deliberate trap, since completion data is mentioned in the passage to tempt you toward D. A useful strategy: when a passage mentions data that is "available but not the primary question," that data almost always appears in a wrong answer choice. Identify the core analytical question first, then eliminate charts that answer a different question.

Question 5

A support center measures average response time for every combination of weekday and hour of day. Supervisors want to spot recurring high-response-time periods quickly, but they must also be able to read the value for a specific weekday-hour combination. Both dimensions are discrete.

Which chart should be selected?

A packed-bubble chart creating one bubble for every weekday-hour combination
A heat map using mark size for response time and color for the number of requests
A line chart connecting all weekday-hour combinations in alphabetical header order
A highlight table using weekday and hour as headers, with color and text for response time (correct answer)

Explanation: When you need to display a metric across two discrete dimensions simultaneously — letting users both spot patterns and read exact values — think about which chart type serves both purposes at once. This question tests your ability to match a visualization to a specific analytical need. A highlight table is purpose-built for this scenario. It places one dimension (weekday) along one axis and the other (hour) along the other, creating a grid where every cell represents a unique combination. Color encodes response time so supervisors can immediately spot clusters of high values — say, Monday mornings or Friday afternoons — while the text label in each cell lets them read the precise figure. Answer D satisfies both requirements in the question: pattern recognition and exact value lookup. Answer A fails because packed-bubble charts don't preserve the two-dimensional grid structure. Bubbles are scattered spatially, making it nearly impossible to trace "which hour on which day" without hunting. Answer B encodes response time through mark size rather than color, which is harder for human perception to interpret quickly and inconsistently with Tableau's standard heat map best practice; additionally, swapping color to represent request count rather than the key metric (response time) buries the very thing supervisors need to spot. Answer C uses a line chart, which implies continuous, connected data with meaningful sequence — but weekday-hour combinations arranged alphabetically carry no meaningful trend, making connecting them with lines misleading and analytically inappropriate. A useful rule of thumb: whenever two discrete dimensions form a matrix and you need both color-based pattern spotting and readable values, a highlight table is almost always the right call on the Tableau exam.

Question 6

A marketing team has approximately $500{,}000$ customer records containing annual website visits and annual purchases. The team wants to determine whether the two measures are related and whether distinct concentrations or nonlinear patterns exist. Displaying individual customers is unnecessary, and ordinary circles would overlap heavily.

Which visualization is most appropriate?

A density scatter plot using website visits and purchases as the two continuous axes (correct answer)
A standard scatter plot placing one opaque circle for every customer record on the same axes
A dual-axis line chart aggregating both measures by customer identification number in sequence
A histogram of purchases with average website visits encoded by bar color within each bin

Explanation: When you encounter a question about visualizing large-scale continuous data, ask yourself two things: How many records exist, and what patterns am I trying to reveal? With

500{,}000

records, overplotting becomes a critical concern, and your chart choice must address it directly. A density scatter plot (A) is the right tool here. Instead of drawing individual points, it divides the two-dimensional space into bins and encodes the count of records in each bin using color or opacity. This lets you immediately see where customers cluster, spot nonlinear relationships, and identify outliers — all without the visual noise of half a million overlapping marks. It directly satisfies every requirement stated in the passage. Choice B fails precisely because it ignores overplotting. Placing one opaque circle per customer creates a solid, unreadable blob where dense regions exist. Even with transparency adjustments,

500{,}000

points overwhelm a standard scatter plot and hide the very patterns you're trying to find. Choice C is a categorical mismatch. A dual-axis line chart connecting customers sequentially by ID treats an arbitrary identifier as a meaningful time-like dimension, which it isn't. This produces a jagged, uninterpretable chart that reveals nothing about the relationship between visits and purchases. Choice D collapses the two-dimensional relationship into a one-dimensional summary. A histogram of purchases shows distribution along one axis, and encoding average website visits as color loses all the granularity needed to detect nonlinear patterns or distinct concentrations. Study tip: On Tableau exam questions, whenever you see large record counts and two continuous measures, density plots exist specifically to solve overplotting — make that your mental shortcut.

Question 7

A finance team needs to explain how an opening cash balance became the closing cash balance. The intervening items include several positive and negative adjustments, and each adjustment should be interpreted as contributing to the running balance rather than as an independent total.

Which visualization most clearly communicates this reconciliation?

A line chart plotting each adjustment amount without calculating the running balance
A grouped bar chart placing every adjustment beside the opening and closing balances
A stacked bar chart treating positive and negative adjustments as portions of one total
A waterfall chart showing the opening balance, sequential adjustments, and closing balance (correct answer)

Explanation: When you see a question about financial reconciliation — explaining how one value transforms into another through a series of steps — ask yourself which chart type preserves the sequential, cumulative story of those changes. That's the core concept being tested here. A waterfall chart is purpose-built for exactly this scenario. It displays an opening value as a grounded bar, then renders each adjustment as a floating bar that either rises or falls from the previous running balance, and finally lands on the closing value. The viewer can trace every step: where you started, what each adjustment contributed, and where you ended. This makes D the correct answer — it's the only option that communicates both the individual adjustments and their cumulative effect on the running balance simultaneously. Choice A fails because plotting raw adjustment amounts on a line chart strips away the running balance entirely. You'd see the size of each change but lose all sense of where the balance stood at any given moment. Choice B, a grouped bar chart, places the opening and closing balances alongside every adjustment as if they're parallel, independent items — this destroys the sequential relationship and makes it nearly impossible to see how the adjustments connect the two endpoint values. Choice C, a stacked bar chart, treats adjustments as portions of a single whole, which implies they combine into one total rather than modify a running balance; it also struggles to represent negative values cleanly. A useful rule of thumb: waterfalls = reconciliations, bridges, and running totals. Any time a question describes a starting point, a series of positive and negative changes, and an ending point, waterfall should immediately come to mind.

Question 8

A quality analyst records the number of defects attributed to each defect type. Management wants to identify the relatively small set of defect types responsible for most defects and see where the cumulative share crosses a selected threshold.

Which visualization best supports this objective?

A stacked area chart ordering defect types alphabetically along the horizontal axis by name
A histogram grouping defect types into bins based on their recorded defect counts
A Pareto chart with descending defect bars and a cumulative-percentage line overlaid (correct answer)
A scatter plot comparing each defect type's count against its rank in alphabetical order

Explanation: When a question asks you to identify a "vital few" causes responsible for most of a problem and track where cumulative impact crosses a threshold, you're squarely in Pareto analysis territory — a core quality-management technique that Tableau supports natively. A Pareto chart, answer C, does exactly what the scenario demands: it sorts defect types in descending order by count (so the largest contributors appear first), displays them as bars, and overlays a cumulative-percentage line. This combination lets you visually pinpoint — for example — where the line crosses 80%, instantly revealing which small set of defect types drives the majority of defects. That dual-axis design is the entire purpose of the chart. The other options each miss a critical requirement. Answer A uses a stacked area chart sorted alphabetically, which obscures the rank-ordering needed to separate major contributors from minor ones — alphabetical sorting is arbitrary and hides patterns. Answer B applies a histogram, which groups ranges of counts into bins; this is useful for understanding a frequency distribution of a continuous variable, but defect types are discrete categories, and binning them by count count collapses the identity of each type entirely. Answer D plots each defect type's count against its alphabetical rank — a scatter plot that confuses alphabetical position with meaningful ranking and provides no cumulative view, making threshold identification impossible. For the Tableau exam, remember this pattern: whenever you see words like "vital few," "cumulative percentage," or "threshold crossing," a Pareto chart is almost certainly the intended answer. No other chart type combines ranked bars with a cumulative overlay in a single view.

Question 9

A logistics company has exact latitude and longitude for each distribution center. Analysts want to compare center-level shipment volume while preserving each center's precise location. State and county boundaries are not meaningful analytical units, although nearby centers may form visible geographic clusters.

Which visualization should be used?

A filled map shading each state by the sum of shipment volume within its borders
A proportional-symbol map placing a size-encoded mark at each center's coordinates (correct answer)
A density map showing shipment concentration while suppressing individual center locations
A treemap grouping distribution centers by state and sizing them by shipment volume

Explanation: When choosing a map type in Tableau, ask yourself three questions: Do you have precise coordinates? Do you need to preserve individual-level detail? Are administrative boundaries the meaningful unit of analysis? Your answers drive everything. Here, you have exact latitude/longitude for each distribution center, you need center-level shipment volume visible, and state/county boundaries are explicitly called out as not meaningful. That combination points directly to a proportional-symbol map (B). Tableau plots each center at its exact coordinates, and the mark size encodes shipment volume — giving you precise location and quantitative comparison in a single view. Nearby centers naturally cluster visually without forcing artificial geographic aggregation. A is the classic trap for geographic data: filled (choropleth) maps aggregate values into administrative regions. The moment you shade by state, you lose individual center locations entirely and imply that state boundaries are analytically meaningful — the passage explicitly rejects both of those outcomes. C, a density map, goes even further in the wrong direction. It smooths data into a continuous heatmap of concentration, which deliberately suppresses individual point locations. That's the opposite of what analysts need here. D, a treemap, abandons geography altogether. Grouping centers by state and sizing by volume might show relative volume, but it destroys spatial context — you can't see where centers actually are or form any geographic interpretation. Study tip: On Tableau exam questions, watch for the phrase "precise location." That's almost always a signal that point-based marks (symbol maps, dot maps) are correct, and any chart that aggregates into regions or hides individual marks is wrong.

Question 10

A sales director reviews actual revenue against a separate target for each of thirty representatives. The dashboard must remain compact and should also distinguish unacceptable, acceptable, and strong performance ranges. The director cares more about target attainment than about comparing representatives' contributions to total revenue.

Which chart is the best choice?

A bullet graph showing actual revenue, a target marker, and qualitative ranges (correct answer)
A stacked bar chart dividing each representative's revenue into performance ranges
A dual-axis line chart connecting actual revenue and target by representative name
A pie chart showing each representative's share of actual company revenue

Explanation: When a question asks you to match a chart type to a business scenario, focus on three things: what the user is measuring, how many data points exist, and what the visual needs to communicate. Here, the director wants to evaluate target attainment across 30 representatives while also communicating performance ranges (unacceptable, acceptable, strong) in a compact space — that combination is the fingerprint of a bullet graph. A bullet graph is purpose-built for exactly this situation. It displays an actual value as a bar, a target as a marker line, and qualitative ranges as background shading — all in a single, narrow horizontal strip. Thirty bullet graphs stack cleanly into a dashboard without overwhelming the viewer, and the range shading directly encodes the performance categories the director cares about. A confirms all three requirements: comparison to target, qualitative ranges, and compactness. B is wrong because a stacked bar chart divides a bar into parts of a whole — it would show revenue composition, not performance against an external target. The "ranges" would be forced into an artificial segment structure that misrepresents the data. C fails because a dual-axis line chart is designed to show trends over time, not cross-sectional comparisons across people; connecting 30 representatives with a line implies a sequential relationship that doesn't exist. D is the clearest mismatch: a pie chart shows proportional share of a total, which directly contradicts the passage's statement that the director cares about target attainment, not contribution to company revenue. As a study tip, remember that bullet graphs are the Tableau go-to whenever you see the phrase "actual vs. target with performance ranges" — that trio almost always points to A on exam questions.