CHOOSING CHARTS

How to choose the right chart

Start with the relationship you need to show, then check whether your table contains categories, ordered values, raw observations, dates or several measures.

TASK-BASED HELPER

What do you need to show?

Choose a task to reveal explicit recommendations. The complete reference below remains available without JavaScript.

Comparison and before/after

Use Bar, Horizontal Bar or Lollipop for one value per category. Use Grouped Bar for several series, and Slope or Dumbbell for exactly two named conditions on one shared scale.

Bars need an honest zero baseline. Paired charts need stable endpoint meaning; they are not time-series charts with missing intermediate dates.

Trend and composition

Use Line or Step Chart for an ordered sequence. Area emphasizes distance from zero, while Stacked Area shows how signed series accumulate with separate positive and negative stacks.

Pie and Doughnut require non-negative parts of one meaningful whole. Stacked Bar compares both totals and composition; a long list of slices is usually clearer as bars.

Distribution and relationship

Histogram starts with raw numeric observations and calculates bins. Box Plot compares raw groups through R7 quartiles and Tukey whiskers. Scatter uses independent numeric X/Y coordinates; Bubble adds a non-negative size whose circle area represents magnitude.

A visible pattern is not a causal conclusion. A Box Plot outlier is not automatically an error.

Process and planning

Funnel shows ordered non-negative stages. Waterfall shows signed changes and explicit total anchors. Gantt represents task ranges with inclusive dates; Timeline represents point events at proportional calendar positions.

Choose the model that matches the source table rather than reshaping unrelated data merely to obtain a particular appearance.

Multivariate tables

Radar compares at least three non-negative metrics on one shared scale. Heatmap maps a matrix to color while preserving the distinction between zero and missing. Combo assigns stable series to bars or lines on one shared Y scale.

These charts answer different questions; the helper below applies explicit rules and does not claim to make an AI or universally optimal choice.

WORKED EXAMPLE

Example data

Demonstration values only-replace them with your own source data.

TaskSuitable chartsRequired data
Compare categoriesBar, Horizontal Bar, LollipopCategory + value
Show a trendLine, Step, AreaOrdered X + value
Inspect a distributionHistogram, Box PlotRaw numeric observations
Show a relationshipScatter, BubbleNumeric X/Y; optional size
Plan workGantt, TimelineTask ranges or dated events

Try the working tools

Bar Graph MakerLine Graph MakerHistogram MakerScatter Plot MakerPie Chart MakerGantt Chart MakerDumbbell Chart MakerHeatmap Maker

Related workflows and guides

GUIDE FAQ

Questions about this task

Yes, but the interpretation changes. Check the data contract and intended message before switching.