Choosing a chart type: which chart fits your data?

Choose a chart from what you want to show: comparison, time, part-to-whole, distribution, relationship, map or flow. Ends at a named chart and its rule.

Choosing a chart type: which chart fits your data?STARTCOMPARE CATEGORIESCHANGE OVER TIMEPARTS OF A WHOLESPREAD AND RELATIONSHIPSPLACES AND FLOWSYesOne value eachTwo to four seriesA before and after pairMore than four seriesTwo or threeA few, one seriesMany pointsUp to fourMore than fourParts of a changing totalOne totalFive or fewer, one dominantSeveral totalsTotals and sharesOnly the sharesSpreadOne groupSeveral groupsFew data pointsLink between twoNoYes, as sizePlacesRate or shareMany areasCount or totalFlowsBetween stages or placesGains and lossesNoCompare or rankChange over timeParts of a wholeSpread or relationshipPlaces or flowsMore, or similar sizesBoth categoricalOnly a handfulChoose a chart typeFor anyone making a chart for areport or slide: pick what you want toshow and how much data you have,and get a chart type and the rule tocheck.Based on UK government guidance(Analysis Function and ONS) and theFinancial Times Visual Vocabulary.These are rules of thumb, not laws.First write the one sentence thechart must say, such as "Sales fell inevery region except the North".Do readers need tolook up exactvalues?Use a tableA well-structured table can often beas powerful as a chart, and it is theright choice when people will readoff precise numbers.Check: right-align numbers and keepgridlines light.What do you want toshow?What are youcomparing acrosscategories?Use a simple bar chartThe standard way to compare thesize of things. Use horizontal barswhen category names are long.Sort bars by value when rankmatters. Keep the gap between barsnarrower than a bar.Check: the value axis must start atzero. Never break it on a bar chart.Use a grouped bar chartAlso called a clustered bar chart. UKAnalysis Function guidance calls twobars per cluster best practice andadvises a limit of four.Check: if readers mainly compareone series across categories, smallmultiples may read better.Use a dot plotA simple way to show the change, orthe range from minimum tomaximum, across many categories.Check: order the categories by oneof the values so the pattern is easyto see.Use a heatmapA grid of two sets of categories, eachcell shaded by its value. Good forshowing patterns between twocategories of data.Check: it is less effective at showingfine differences in amounts. Addvalue labels or a table if they matter,or try small multiples.How many timepoints?Use a slope chartGood for showing change as long asthe data can be simplified into two orthree points without missing a keypart of the story.Check: label both ends of each linedirectly. With many categories thelines cross into a tangle.Use a column chartONS guidance suits column charts toa single series with only a few datapoints, and to flow data such ascounts per month.Check: the axis must start at zero. Ifthat hides the change, use a linechart instead.How many series?Use a line chartThe standard way to show achanging time series. UK AnalysisFunction guidance says aim for amaximum of four lines.Check: unlike a column chart, a linechart axis can start above zero whenthat helps. Keep the scale honest.Use small multiple linechartsOne small chart per series on thesame scales. Readers can see eachseries without a tangle of lines.Check: keep the axes identical acrosspanels, or comparisons mislead.Use a stacked area chartShows how a total changes over timeand roughly what makes it up.Check: only the bottom layer has aflat baseline, so changes in the upperlayers are hard to read. Use withcare.One total or several?Use part-to-whole charts only whenthe parts add up to a meaningful100%. Not for rates, incomplete data,or survey questions where peopletick several boxes.How many parts,and is onedominant?Use a pie or donut chartUK Analysis Function guidanceallows pie charts with five categoriesor fewer and a dominant category.ONS says ideally three or four, nevermore than six.A donut works the same way andleaves room for the total in thecentre.Check: if segments are similar in size,readers can't compare them. Use abar chart instead.Do the totals matter,or only the shares?Use a stacked bar chartCompares the composition of totalsacross groups.Check: keep to four or five segmentsper bar and group the rest as Other.Only the first segment has acommon baseline.Use a 100% stacked barchartEvery bar runs to 100%, so readerscompare proportions across groupswhatever the size of each total.Check: say the totals somewhere. A100% bar hides that one group maybe ten times bigger than another.Spread of onemeasure, or a linkbetween two?How many groups?Use a histogramThe standard way to show adistribution. Keep the gaps betweencolumns small to highlight the shape.Check: the shape depends on binwidth. Try a few widths before youchoose.Use box plotsSummarise several distributions sideby side, showing the median and therange of the data.Check: a box plot hides shape, suchas two peaks. Explain the box andwhiskers to a general audience.Use a dot strip plotShows every individual value alongone line, so nothing is hidden bysummary.Check: dots with the same valueoverlap. Jitter or stack them.Is there a thirdmeasure to show?Use a scatter plotThe standard way to show therelationship between two continuousvariables, each on its own axis.Check: readers tend to assume arelationship is causal unless you tellthem otherwise.Use a bubble chartLike a scatter plot, with each circlesized by a third variable.Check: size circles by area, notradius, and keep the number ofbubbles low enough to read.Places on a map, orflows betweenstates?Is the value a rate ora count?How many areas?Use a choropleth mapShades each area by its value. ONSsuggests five colour bands, or up tosix on a diverging scale.Check: always map rates, not totals.Counts mostly show where the big orpopulous areas are.Use a proportional symbolmapPlaces a symbol sized by value oneach area. Use it for totals ratherthan rates.Check: small differences betweensymbols are hard to see. Label thekey values.What kind of flow?Use a Sankey diagramShows the volume moving from onecondition to at least one other. Goodfor tracing the outcome of a complexprocess.Check: too many nodes turn it into atangle. Group small flows together.Use a waterfall chartShows how a starting value becomesan ending value through positive andnegative steps, such as a budget.Check: label each bar with its valueand make the start and end totalsvisually distinct.

Start

  1. Choose a chart type

    For anyone making a chart for a report or slide: pick what you want to show and how much data you have, and get a chart type and the rule to check.

    Based on UK government guidance (Analysis Function and ONS) and the Financial Times Visual Vocabulary. These are rules of thumb, not laws.

    First write the one sentence the chart must say, such as "Sales fell in every region except the North".

  2. Do readers need to look up exact values?
  3. Use a table

    A well-structured table can often be as powerful as a chart, and it is the right choice when people will read off precise numbers.

    Check: right-align numbers and keep gridlines light.

  4. What do you want to show?

Compare categories

  1. What are you comparing across categories?
  2. Use a simple bar chart

    The standard way to compare the size of things. Use horizontal bars when category names are long.

    Sort bars by value when rank matters. Keep the gap between bars narrower than a bar.

    Check: the value axis must start at zero. Never break it on a bar chart.

  3. Use a grouped bar chart

    Also called a clustered bar chart. UK Analysis Function guidance calls two bars per cluster best practice and advises a limit of four.

    Check: if readers mainly compare one series across categories, small multiples may read better.

  4. Use a dot plot

    A simple way to show the change, or the range from minimum to maximum, across many categories.

    Check: order the categories by one of the values so the pattern is easy to see.

  5. Use a heatmap

    A grid of two sets of categories, each cell shaded by its value. Good for showing patterns between two categories of data.

    Check: it is less effective at showing fine differences in amounts. Add value labels or a table if they matter, or try small multiples.

Change over time

  1. How many time points?
  2. Use a slope chart

    Good for showing change as long as the data can be simplified into two or three points without missing a key part of the story.

    Check: label both ends of each line directly. With many categories the lines cross into a tangle.

  3. Use a column chart

    ONS guidance suits column charts to a single series with only a few data points, and to flow data such as counts per month.

    Check: the axis must start at zero. If that hides the change, use a line chart instead.

  4. How many series?
  5. Use a line chart

    The standard way to show a changing time series. UK Analysis Function guidance says aim for a maximum of four lines.

    Check: unlike a column chart, a line chart axis can start above zero when that helps. Keep the scale honest.

  6. Use small multiple line charts

    One small chart per series on the same scales. Readers can see each series without a tangle of lines.

    Check: keep the axes identical across panels, or comparisons mislead.

  7. Use a stacked area chart

    Shows how a total changes over time and roughly what makes it up.

    Check: only the bottom layer has a flat baseline, so changes in the upper layers are hard to read. Use with care.

Parts of a whole

  1. One total or several?

    Use part-to-whole charts only when the parts add up to a meaningful 100%. Not for rates, incomplete data, or survey questions where people tick several boxes.

  2. How many parts, and is one dominant?
  3. Use a pie or donut chart

    UK Analysis Function guidance allows pie charts with five categories or fewer and a dominant category. ONS says ideally three or four, never more than six.

    A donut works the same way and leaves room for the total in the centre.

    Check: if segments are similar in size, readers can't compare them. Use a bar chart instead.

  4. Do the totals matter, or only the shares?
  5. Use a stacked bar chart

    Compares the composition of totals across groups.

    Check: keep to four or five segments per bar and group the rest as Other. Only the first segment has a common baseline.

  6. Use a 100% stacked bar chart

    Every bar runs to 100%, so readers compare proportions across groups whatever the size of each total.

    Check: say the totals somewhere. A 100% bar hides that one group may be ten times bigger than another.

Spread and relationships

  1. How many groups?
  2. Use a histogram

    The standard way to show a distribution. Keep the gaps between columns small to highlight the shape.

    Check: the shape depends on bin width. Try a few widths before you choose.

  3. Use box plots

    Summarise several distributions side by side, showing the median and the range of the data.

    Check: a box plot hides shape, such as two peaks. Explain the box and whiskers to a general audience.

  4. Use a dot strip plot

    Shows every individual value along one line, so nothing is hidden by summary.

    Check: dots with the same value overlap. Jitter or stack them.

  5. Is there a third measure to show?
  6. Use a scatter plot

    The standard way to show the relationship between two continuous variables, each on its own axis.

    Check: readers tend to assume a relationship is causal unless you tell them otherwise.

  7. Use a bubble chart

    Like a scatter plot, with each circle sized by a third variable.

    Check: size circles by area, not radius, and keep the number of bubbles low enough to read.

Places and flows

  1. Places on a map, or flows between states?
  2. Is the value a rate or a count?
  3. How many areas?
  4. Use a choropleth map

    Shades each area by its value. ONS suggests five colour bands, or up to six on a diverging scale.

    Check: always map rates, not totals. Counts mostly show where the big or populous areas are.

  5. Use a proportional symbol map

    Places a symbol sized by value on each area. Use it for totals rather than rates.

    Check: small differences between symbols are hard to see. Label the key values.

  6. What kind of flow?
  7. Use a Sankey diagram

    Shows the volume moving from one condition to at least one other. Good for tracing the outcome of a complex process.

    Check: too many nodes turn it into a tangle. Group small flows together.

  8. Use a waterfall chart

    Shows how a starting value becomes an ending value through positive and negative steps, such as a budget.

    Check: label each bar with its value and make the start and end totals visually distinct.

Outcomes

Use a table

A well-structured table can often be as powerful as a chart, and it is the right choice when people will read off precise numbers.

Check: right-align numbers and keep gridlines light.

You get here from step 2, Do readers need to look up exact values? (Yes).

Use a simple bar chart

The standard way to compare the size of things. Use horizontal bars when category names are long.

Sort bars by value when rank matters. Keep the gap between bars narrower than a bar.

Check: the value axis must start at zero. Never break it on a bar chart.

You get here from step 5, What are you comparing across categories? (One value each), step 18, How many parts, and is one dominant? (More, or similar sizes), step 33, How many areas? (Only a handful).

Use a grouped bar chart

Also called a clustered bar chart. UK Analysis Function guidance calls two bars per cluster best practice and advises a limit of four.

Check: if readers mainly compare one series across categories, small multiples may read better.

You get here from step 5, What are you comparing across categories? (Two to four series).

Use a dot plot

A simple way to show the change, or the range from minimum to maximum, across many categories.

Check: order the categories by one of the values so the pattern is easy to see.

You get here from step 5, What are you comparing across categories? (A before and after pair).

Use a heatmap

A grid of two sets of categories, each cell shaded by its value. Good for showing patterns between two categories of data.

Check: it is less effective at showing fine differences in amounts. Add value labels or a table if they matter, or try small multiples.

You get here from step 5, What are you comparing across categories? (More than four series), step 28, Is there a third measure to show? (Both categorical).

Use a slope chart

Good for showing change as long as the data can be simplified into two or three points without missing a key part of the story.

Check: label both ends of each line directly. With many categories the lines cross into a tangle.

You get here from step 10, How many time points? (Two or three).

Use a column chart

ONS guidance suits column charts to a single series with only a few data points, and to flow data such as counts per month.

Check: the axis must start at zero. If that hides the change, use a line chart instead.

You get here from step 10, How many time points? (A few, one series).

Use a line chart

The standard way to show a changing time series. UK Analysis Function guidance says aim for a maximum of four lines.

Check: unlike a column chart, a line chart axis can start above zero when that helps. Keep the scale honest.

You get here from step 13, How many series? (Up to four).

Use small multiple line charts

One small chart per series on the same scales. Readers can see each series without a tangle of lines.

Check: keep the axes identical across panels, or comparisons mislead.

You get here from step 13, How many series? (More than four).

Use a stacked area chart

Shows how a total changes over time and roughly what makes it up.

Check: only the bottom layer has a flat baseline, so changes in the upper layers are hard to read. Use with care.

You get here from step 13, How many series? (Parts of a changing total).

Use a pie or donut chart

UK Analysis Function guidance allows pie charts with five categories or fewer and a dominant category. ONS says ideally three or four, never more than six.

A donut works the same way and leaves room for the total in the centre.

Check: if segments are similar in size, readers can't compare them. Use a bar chart instead.

You get here from step 18, How many parts, and is one dominant? (Five or fewer, one dominant).

Use a stacked bar chart

Compares the composition of totals across groups.

Check: keep to four or five segments per bar and group the rest as Other. Only the first segment has a common baseline.

You get here from step 20, Do the totals matter, or only the shares? (Totals and shares).

Use a 100% stacked bar chart

Every bar runs to 100%, so readers compare proportions across groups whatever the size of each total.

Check: say the totals somewhere. A 100% bar hides that one group may be ten times bigger than another.

You get here from step 20, Do the totals matter, or only the shares? (Only the shares).

Use a histogram

The standard way to show a distribution. Keep the gaps between columns small to highlight the shape.

Check: the shape depends on bin width. Try a few widths before you choose.

You get here from step 24, How many groups? (One group).

Use box plots

Summarise several distributions side by side, showing the median and the range of the data.

Check: a box plot hides shape, such as two peaks. Explain the box and whiskers to a general audience.

You get here from step 24, How many groups? (Several groups).

Use a dot strip plot

Shows every individual value along one line, so nothing is hidden by summary.

Check: dots with the same value overlap. Jitter or stack them.

You get here from step 24, How many groups? (Few data points).

Use a scatter plot

The standard way to show the relationship between two continuous variables, each on its own axis.

Check: readers tend to assume a relationship is causal unless you tell them otherwise.

You get here from step 28, Is there a third measure to show? (No).

Use a bubble chart

Like a scatter plot, with each circle sized by a third variable.

Check: size circles by area, not radius, and keep the number of bubbles low enough to read.

You get here from step 28, Is there a third measure to show? (Yes, as size).

Use a choropleth map

Shades each area by its value. ONS suggests five colour bands, or up to six on a diverging scale.

Check: always map rates, not totals. Counts mostly show where the big or populous areas are.

You get here from step 33, How many areas? (Many areas).

Use a proportional symbol map

Places a symbol sized by value on each area. Use it for totals rather than rates.

Check: small differences between symbols are hard to see. Label the key values.

You get here from step 32, Is the value a rate or a count? (Count or total).

Use a Sankey diagram

Shows the volume moving from one condition to at least one other. Good for tracing the outcome of a complex process.

Check: too many nodes turn it into a tangle. Group small flows together.

You get here from step 36, What kind of flow? (Between stages or places).

Use a waterfall chart

Shows how a starting value becomes an ending value through positive and negative steps, such as a budget.

Check: label each bar with its value and make the start and end totals visually distinct.

You get here from step 36, What kind of flow? (Gains and losses).