Making PowerPoint charts easier to read

Before you build a chart slide, write down the question your audience needs answered. Which category is largest? How did performance change? How does the actual result compare with the target?

Only then choose the chart, and format it so the reader can see the comparison that matters and check what it means.

Establish what your data represents

Before choosing a visual, pin down the definitions: units, reporting periods, who or what is included, and whether figures are totals, averages, medians, percentages, or rates.

Check whether categories overlap. If one person can be counted in several categories, those categories can't be slices of a pie chart. Tell a missing value apart from zero, and either explain missing data or show the gap clearly.

Keep a record of your sources that someone else could check, including any calculations you ran on the raw data.

Match a chart to a comparison

Use this table as a starting point:

  • Which categories are larger?
    Chart to consider: Bar chart
    Check before using it: Comparable units and clear category labels

  • How did a measure change over time?
    Chart to consider: Line chart
    Check before using it: Ordered periods and clearly marked gaps

  • What contributes to a total?
    Chart to consider: Stacked bar
    Check before using it: Mutually exclusive categories and a defined total

  • How do two numeric variables relate?
    Chart to consider: Scatterplot
    Check before using it: Meaningful measures on both axes

  • How do increases and decreases explain a total?
    Chart to consider: Waterfall chart
    Check before using it: Components reconcile to the stated closing value

A table may work better when your audience needs precise values across several measures. Try something simple first and only add complexity when your audience needs it.

Write a heading supported by your chart

“Customer support” names a subject. “Weekend response times remain above target” tells people what you found. Use that second kind of heading when your data supports a clear conclusion, and include the period or segment if it matters.

If a chart is exploratory, a descriptive heading is fine. You can invite discussion without claiming a result you haven't established. Either way, check that the heading still makes sense to someone reading the slide on their own.

Simplify without hiding necessary context

Remove anything that repeats information. If you label each series directly, you probably don't need a legend. Keep gridlines only if they help people estimate values, leave enough space around labels, and format numbers consistently.

Keep the units, the baseline, and any caveat needed to read the comparison, and make sure the source line is readable. Don't cut a time series short just because the longer view complicates your conclusion. Choose a period that fits the question and explain anything you've left out.

Bar charts need a zero baseline, because bar length represents quantity. If you need to show a small change in detail, pick a format that makes the change itself the subject.

Use emphasis consistently

Highlight the series or category that matters, but keep the rest visible enough to give context. Use the same color for the same category throughout the deck. If blue means actual results on one slide, don't use it for targets on the next.

Add labels or other cues so the meaning doesn't depend on color alone. Annotations should say what happened. “New eligibility rules began in May” gives context. “Significant change” leaves readers unsure whether you mean big or statistically significant.

Show a percentage with its basis

Here's a made-up example. A support team handled 200 tickets in a baseline month and 250 in a later month. That's an increase of 50, or 25% of the original 200.

If the later month had more working days, a daily rate might tell you more. Show whichever measure answers your question and explain how it's defined. For survey results, include the sample size and, if it matters, the question wording. A percentage on its own can hide a very small base.

Don't confuse percentage points with percentage change. A rate that goes from 20% to 25% has risen by five percentage points, which is a 25% increase.

Keep a recurring chart maintainable

If the chart will be updated, keep the data editable and note where it comes from. A real PowerPoint chart lets you edit its data directly. A picture of a chart has to be replaced every time.

Decide whether to embed the data, link to an external file, or paste a static image. Check your organization's rules before sending out a file with underlying data in it. Then try an ordinary update before you finalize the layout, because longer labels or another reporting period may need more space.

Review your finished slide with a reader

Ask someone to tell you the finding, the comparison period, and the source, and whether anything is unclear. Then look at the slide the way your audience will. A chart that's easy to read zoomed in can be hard to read in a meeting window.

If you have to spend ages explaining the axes and categories out loud, the labels need work.

Sources

1. Office for National Statistics: Choosing a chart type
https://service-manual.ons.gov.uk/data-visualisation/chart-types/choosing-a-chart-type

2. Office for National Statistics: Axes and gridlines
https://service-manual.ons.gov.uk/data-visualisation/guidance/axes-and-gridlines

3. Office for National Statistics: Chart text
https://service-manual.ons.gov.uk/data-visualisation/guidance/chart-text

4. Office for National Statistics: Using colors in charts
https://service-manual.ons.gov.uk/data-visualisation/colours/using-colours-in-charts

5. Microsoft: Change the data in an existing chart
https://support.microsoft.com/en-gb/powerpoint/change-the-data-in-an-existing-chart

‍ ‍

Want your own slides to look professional?

Book a call or email us.

Previous
Previous

7 top presentations for business-case evaluation

Next
Next

6 top presentations for national government departments