Choosing the correct chart

There are eight common relationships that charts display. Prioritise what you want to highlight in the data and choose the chart type accordingly.

The eight common relationships within data are the following:

  • comparisons of magnitude (size)
  • time series
  • ranking
  • part-to-whole
  • deviation
  • distribution
  • correlation
  • spatial (maps will be covered separately in phase 4)

Choice of data

Consider the message you want to communicate and choose your data accordingly. Your message might be better conveyed by deriving variables.

Comparing data sets – shared horizons

Start data that are likely to be compared from the same point on a chart – a shared horizon. Use a clustered chart to compare values; only the first category is easily comparable in stacked bar charts.

Do

Example of chart allowing easy comparisons

Adoptions by sex
England and Wales, 1998 to 2012

A bar and line chart with the line showing the total of adoptions by sex, and two bars for the breakdown of adoption by males and females.

Do not

Example of stacked bar chart where comparability is more difficult

Adoptions by sex
England and Wales, 1998 to 2012

A stacked bar chart only showing the breakdown of adoption by males and females.

Comparisons of magnitude (size)

To show:

  • X is bigger than Y
  • A is almost twice the size of B

Comparisons of size are shown most effectively as horizontal or vertical bars. Always begin the y-axis at zero.

Small differences in magnitude, starting the y-axis at a non-zero value

If there are small differences between values sometimes it is necessary to start the y-axis at a non-zero value.

Always put a break in the y-axis if you do not start at zero.

Example of chart with a break in the y-axis

A bar chart with a break in the y axis at 750 to show that one category is slightly higher in value than the others.

Use a dot (or other symbol) plot to make comparisons between values. The size of the visual element representing the data (dot position) is representative of the data value itself.

Example of chart using a dot plot to make comparisons

A scatter chart using dot plots to show comparisons between the values.A scatter chart using cross plots to show comparisons between the values.

You can also show small differences between data by adjusting the deviation. This is changing what data can be seen from a chosen value (the deviation section has more information).

Example of chart showing deviation between categories

A bar chart showing the deviation between categories, with the UK average equal to 777.5

Time series

Rather than over-emphasising month-to-month or point-to-point comparisons of estimates a time series can show:

  • change
  • trend
  • fluctuation
  • growth
  • decline
  • increase
  • decrease

Time series axes

Time should always run from left to right along the horizontal axis.

Time series charts

A time series with regular intervals can be presented using line charts, bar charts or a combination of both.

Bar charts for time series

Bars should be used to emphasize individual values at distinct points in time. Use them when data points are at equal intervals.

Do

Example of bar chart showing increases and decreases over time

A bar chart showing increases and decreases in data over a period of equal ten-year intervals from 1900 to 2010.

Example of bar chart showing gradual decrease over time

A bar chart showing the gradual decrease in data over a period of equal ten-year intervals from 1900 to 2010.

Line charts for time series

A line chart will emphasise the overall pattern of the data and highlight trends. Use them when you have lots of data points or just a few. Multiple times series should always use line charts.

Do

Example of line chart showing gradual decrease over time

A line chart showing a gradual decrease over time.

Example of line chart showing change over time

A line chart showing sharp spikes in increases and decreases over time.

Dot plot with line for time series

Use a dot plot with a line when there are lots of data points or the interval between data points is not equal. Show if data are irregular.

Do

Example of dot plot with a regular axis

A dot plot chart with a irregular data points joined together with a line. The x axis increases in ten-year intervals and there is a large gap in data between 1940 and 1960.

Do not

Example of dot plot with an irregular axis

A dot plot chart with an irregular axis making the points harder to read. The x axis increases in intervals of five and ten with large gaps between.

Multiple time series

Multiple time series should not be presented using bar charts. Use a line chart to make sure the trends in the series are clear. Use points on a line to highlight individual data points, to read specific values or highlight when the data were sampled.

Do

Example of line chart to show multiple time series

A line chart with data points highlighted for easy comparison, showing a blue line for England and an orange line for Wales.

Do not

Example of bar chart to show multiple time series

A bar chart with a blue bar for England and orange bar for Wales, where it is more difficult to compare the differences in the data.

Small changes over time, not starting the y-axis at zero

Time series charts do not have to begin at zero, if a chart does not start at zero this must be indicated by breaking the y-axis in an obvious way.

Scale of the axes

A chart can tell a very different story depending on the scale of the axes.

This chart gives the impression that the measles, mumps and rubella (MMR) vaccination level has remained high and fairly stable.

Example of chart with the y-axis at zero showing a fairly stable trend

An overview

MMR vaccination uptake at age 1 year
UK, 1992 to 2012

A line chart with the y axis starting at zero, suggesting that the vaccination level for measles, mumps and rubella has remained fairly high and stable.

When the y-axis is altered a different picture emerges showing that the measles, mumps and rubella vaccination has dropped considerably since 1997.

Example of chart with the y-axis altered showing a more dramatic trend

A more focused view

MMR and Diphtheria vaccination uptake at age 1 year
UK, 1992 to 2012

A line chart with a break in the axis at 75% showing that the measles, mumps and rubella vaccination has dropped considerably since 1997

You can use two charts with different axes scales to ensure that the data are represented without bias whilst highlighting the important message.

Ranking

To show:

  • greater than
  • less than
  • equal to
  • from lowest to highest

Use bar charts to show data that are ranked, in either ascending or descending order. Horizontal bars should be used.

A bar chart should always be ranked by value, unless there is a natural order to the data (for example, age or time).

Example of chart with no ranking order

A rotated bar chart with no order to the ranking of categories, making it harder to compare values.

To highlight the highest values the largest value should be at the top of the chart.

Example of chart with a clear ranking order from highest value

Descending, largest values highlighted

A rotated bar chart ranked with the largest values at the top and the smallest values at the bottom.

To highlight the lowest values the smallest value should be at the top of the chart.

Example of chart with clear ranking order from lowest value

Ascending, smallest values highlighted

A rotated bar chart with the smallest values at the top of the chart and the largest at the bottom.

If you are talking about data in terms of first, second or third, or “the top 10”, they should always be in descending order.

Example of chart ranking the top 10 in descending order

Top 10 girls’ baby names
England, 2013

A rotated bar chart showing the top ten baby names for girls, with the most popular at the top and the following nine in descending order.

Plotting a change in rank

Use a slope chart to highlight a change in rank.

Example of slope chart showing change in ranking order

A slope chart showing how the rankings of most popular baby names for boys have changed between 2003 and 2013, with the most popular at the top and the least popular at the bottom.

Ranking multiple series

Rank the most important or recent data if there are multiple series and the other data sets should be ordered correspondingly.

Part-to-whole

Part to whole relationships

To show:

  • ratio
  • percentage
  • proportion
  • share
  • breakdown
  • make up
  • hierarchy

Bar charts and pie charts should be used to show part to whole relationships.

Pie charts should only be used when there are less than six categories, otherwise use a bar chart or, if appropriate, combine categories.

Rank the categories in a pie chart and start the first segment at the 12 o’clock position.

Segments of a pie chart must sum to 100%. If the categories do not sum to a meaningful whole, do not use a pie chart. Where appropriate categories can be combined to highlight a certain message but should never be removed.

Example of pie chart ranked by size of category

All main categories included
A pie chart showing six categories of religion, with the largest section for Christianity.

Religion categories combined
A pie chart showing three combined religions categories, with the largest section for Religion stated.

Example of incorrect use of pie chart with categories removed

No religion and not stated categories removed

If no categories are dominant use a bar chart to illustrate your data.

Example of bar chart where no categories are noticeably dominant

A bar chart showing categories in descending order, where a single category is not noticeably more dominant than the others.

Example of incorrect use of pie chart where no categories are dominant

A pie chart where all categories appear to to be the same size, as there are only minimal percentage differences between them.

Multiple part to whole

Use bars to enable comparisons to be made across multiple part to whole charts.

Example of bar chart used to compare multiple part to whole

To enable comparisons within sub-categories

A rotated bar chart with categories stacked to show the part to whole breakdown.

To enable comparisons across sub-categories

A rotated bar chart with individual categories listed on the y axis and bars for the sub-categories grouped together.

Deviation

To show:

  • number of times more than the average
  • the difference from 

Use a bar chart to plot deviation from a fixed value, or series of values.

Example of deviation where the value of data is most important

Gross disposable household income (GDHI) per head (£)
England, 2011

A rotated bar chart showing deviation where the value of data is most important, with an annotation to compare England as a whole with individual English regions.

Example of deviation where the amount of change is most important

GDHI per head index comparison with England average
England, 2011

A rotated bar chart only showing the deviation of individual English regions from the average from the whole of England.

Use small multiples to plot deviation for multiple series. The axes should be identical for each small multiple.

Example of deviation with small multiples

A small multiple chart showing deviation for multiple series over time, with an individual chart showing the deviation from the England average for 2001, 2002, 2003 and 2004.

Distribution

To show:

  • frequency
  • distribution
  • profile
  • range
  • concentration
  • normal curve
  • population pyramid
  • shape

For one variable

Use a histogram to show a distribution of data. Use small gaps between the bars to emphasise the profile of the data.

Example of histrogram chart showing one variable

Usually resident population aged 0 to 21 years
UK, 2013

A histogram with narrow bars that are close together to show the difference in ages in the usually resident population of the UK in 2013.

For two variables

Use a population pyramid to show the distribution of comparable data sets and highlight differences in the profile of the data.

Example of population pyramid showing two variables

A population pyramid with narrow bars that are close together to show the differences between the data for males and females.

For more than two variables

To compare four variables population pyramids can be overlaid, with the least important data set displayed using an outline pyramid instead of bars.

Example of population pyramid showing multiple variables

A population pyramid with narrow bars that are close together to show the differences between the data for males and females, with a bar for 2010 and a line for 1995.

Small multiple charts can also be used for multiple distributions. Use the same scale to enable comparison across charts.

Example of small multiples chart

A small multiple line chart showing the differences in the distribution between countries.

Box-plots can also be used to compare distributions with two or more variables.

Example of box plot

A box plot chart to show the distribution through boxes and confidence intervals.

Correlation

Correlation charts are often associated with causality and they should be used with caution.

Correlation can show:

  • increases with
  • relates to
  • changes with
  • varies with
  • caused by

Anscombe’s Quartet

Anscombe’s quartet is a powerful illustration of the drawback of relying solely on basic descriptive statistics to summarise data. The data in all four of the graphs in the quartet are virtually identical when using standard descriptive methods. Looking at your data before analysing it is something that Anscombe was passionate about.

Example of Anscombe’s Quartet

A scatter and line chart showing an example of a simple, linear relationship between data.A scatter and plot chart showing an example of a non-linear relationship between data.

A scatter and line chart showing an example of a mostly linear relationship between data, with one outlier.A scatter and line chart showing an example of where there doesn't seem to be a relationship between the data, other than one high outlier.

We are constantly improving based on research and best practice. Any significant changes to our guidance are available on the Updates page.