# How to choose the right chart: match the chart to the message on your slide

> Choose the chart from the message, not from the data. Column and bar charts compare categories, a line shows change over time, a waterfall explains how one number became another and a scatter plot shows a relationship. Pie charts only work for a few parts of one whole: Microsoft's own guidance is one data series, no negative values and no more than seven categories. If readers need exact values, use a table. Whatever the type, write the slide title as the finding.

- Source: https://ai-presentations.com/guides/choosing-the-right-chart/
- Updated: 21 October 2026
- Language: English
- German version: https://ai-presentations.com/de/ratgeber/das-richtige-diagramm/

The right **chart** depends on the message you want the reader to take away, not on the shape of your data. Comparing categories calls for bars, change over time for a line, how one number became another for a waterfall, and a relationship between two measures for a scatter plot. A pie chart is the one type that comes with strict conditions. This guide gives you the choice by message, the traps that make a chart misleading and the steps for getting a clean result in PowerPoint or from an AI tool.

## Which chart should I use for my message?

Start from the sentence you want the slide title to say, then pick the chart that shows exactly that sentence. Gene Zelazny's book *Say It with Charts* sorts the choice into five relationships: component (parts of a whole), item (ranking and comparison), time series, frequency distribution and correlation. The table below maps them to the chart types you will actually use.

| Message                           | Chart                                               | Switch when                                                                             |
| --------------------------------- | --------------------------------------------------- | --------------------------------------------------------------------------------------- |
| Compare a few categories          | Column chart, or a bar chart if the labels are long | There are more than about a dozen categories: sort them into a bar chart or use a table |
| Rank items                        | Horizontal bar chart, sorted by value               | The exact numbers matter more than the order: use a table                               |
| Change over time                  | Line chart, or columns for a few periods            | Many series cross each other: show the two that matter and gray out the rest            |
| Part of a whole                   | Stacked bar, or a pie chart with few parts          | There are many parts: show their shares as a sorted bar chart                           |
| How one value became another      | Waterfall chart                                     | There are only two values: state both in the title                                      |
| Spread of values                  | Histogram                                           | You have few data points: list them                                                     |
| Relationship between two measures | Scatter plot                                        | You cannot explain the pattern in one sentence                                          |
| Exact values                      | Table                                               | Readers only need the pattern                                                           |

The reason bars come first is perception, not taste. In a 1984 paper in the *Journal of the American Statistical Association*, William Cleveland and Robert McGill found that people judge position along a common scale more accurately than angle or area. A bar chart relies on position and length. A pie chart relies on angle. Microsoft's page on [available chart types in Office](https://support.microsoft.com/en-us/excel/available-chart-types-in-office) lists the full set, including histogram, scatter, treemap, funnel and waterfall charts, and says what each is for.

## When should I use a bar, column or line chart?

Use columns or bars to compare categories and a line for change over time, as Microsoft's chart-types page does: bar charts compare individual items and line charts show continuous data over time on an evenly scaled axis. Three habits make the difference between a chart that reads at a glance and one that needs a caption:

- **Sort by value** unless the categories have a natural order such as months or age bands.
- **Start the value axis at zero** for bars and columns, because the length of the bar is the value.
- **Highlight one bar** in the accent color and leave the others gray, so the eye lands on the message.

Choose bars over columns when the labels are long, because horizontal text is easier to read than rotated text. Then write the title. A label such as "Revenue by region" describes the chart. A finding tells the reader what to see in it. The guide to [action titles](https://ai-presentations.com/guides/action-titles/) goes into the method.

> **Avoid: The title names the chart**
>
> Revenue by region, Q3 2025 and Q3 2026

> **Do: The title states the finding**
>
> Revenue grew in every region; the Nordics led with +27%

*Two series, four regions, one finding in the title and the source named under the chart*

4. Revenue grew in every region; the Nordics led with +27%

*One highlighted bar carries the message; the other bars are context*

3. Inventory and receivables tie up €11.2m, and finished goods alone sit about €1.6m above benchmark

## How do I show a trend over time?

Use a line chart, with as few lines as the message needs. A line shows direction, speed and turning points better than any other type. When there are several series, label the lines directly at their ends instead of sending the reader to a legend, and highlight the one that matters.

Microsoft also says on the same page that it prefers a line chart over a non-stacked area chart, because one series can hide another. A single series is the exception: an area under one line makes growth feel solid, which is why the example below uses it for [annual recurring revenue (ARR)](https://ai-presentations.com/glossary/arr/). For a handful of periods, columns are fine too, and they make it easier to read each period's value.

*One series over five quarters: an area under a single line works because nothing can hide behind it*

5. ARR grew 4.2x in twelve months to 46 customers

## When is a pie chart the right choice?

Rarely, and only under the conditions Microsoft gives: one data series, no negative values, almost no zero values and no more than seven categories. Microsoft also says doughnut charts are not easy to read, so skip them. A pie chart earns its place when you show two to four parts of one whole and the message is roughly how big one part is, such as "about half of revenue comes from one customer".

As soon as the reader has to compare slices, switch to a sorted bar chart. Cleveland and McGill's finding explains why: comparing angles is harder than comparing lengths. Direct labels with values help a pie chart, but they are a sign that a table or a bar chart would have been clearer.

## How do I show how one number became another?

Use a waterfall chart, also called a bridge chart. It starts at one total, adds each increase and decrease as a floating bar and ends at the new total, which makes it the standard chart for profit bridges and budget variances. Microsoft describes it as showing a running total as values are added or subtracted. The glossary entry on the [waterfall chart](https://ai-presentations.com/glossary/waterfall-chart/) covers how to read one.

Whichever tool draws it, the input is the same: the start total, each increase and decrease, and the end total. Check that the steps add up to the end value. Color increases, decreases and totals differently or label the bars directly, and make the title name the biggest driver. The board example below does exactly that.

*An EBITDA bridge: the title names the two biggest drivers, the takeaway says what continues*

5. Margin expansion came mostly from volume and better network utilization

## What makes a chart misleading?

Most bad charts fail in the same few ways, and nearly all of them come from decoration or from a scale that exaggerates. The glossary entry on the [data-ink ratio](https://ai-presentations.com/glossary/data-ink-ratio/) explains the principle: every mark on the chart should carry information.

| Trap                                 | Why it misleads                                                                               | Fix                                           |
| ------------------------------------ | --------------------------------------------------------------------------------------------- | --------------------------------------------- |
| Bar axis that does not start at zero | Small differences look large                                                                  | Start at zero, or switch to a line chart      |
| 3D effects and shadows               | Perspective distorts the sizes of bars and slices                                             | Flat bars and slices, no shadows              |
| Two value axes                       | The reader cannot tell which line belongs to which scale, and the crossing point is arbitrary | Two small charts side by side, or an index    |
| More than about four lines           | A spaghetti of colors with a legend to decode                                                 | Highlight one or two lines, gray out the rest |
| Color without meaning                | Readers hunt for a code that is not there                                                     | One accent color, everything else gray        |
| A pie with many slices               | Small slices cannot be compared                                                               | A sorted bar chart                            |

> **Avoid: Eight lines and a legend**
>
> Eight regions in eight colors on one line chart, with a legend at the bottom and the title "Revenue by region".

> **Do: Two lines, one highlighted, labeled directly**
>
> Nordics in the accent color and the group average in gray, each labeled at its end, with the title "The Nordics grew faster than the group in every quarter".

Also check what the chart leaves out. If a value is missing for a period, show the gap or say so in a note. A missing value silently drawn as zero is a false statement.

## When is a table better than a chart?

When readers need exact values, when you have only a handful of data points or when the numbers have different units. A chart shows a pattern. A table lets someone look up a figure. If your slide has to carry both, put the chart on the slide and the table in the appendix, or highlight the one row that matters in the table itself. The guide to [presentation rules](https://ai-presentations.com/guides/presentation-rules/) explains why one message per slide keeps this simple.

## How do I make charts in PowerPoint look consistent?

Set the theme first, then insert the charts. Microsoft's page on [charts and graphs in presentations](https://support.microsoft.com/en-us/office/use-charts-and-graphs-in-your-presentation-c74616f1-a5b2-4a37-8695-fbcc043bf526) describes the path: choose **Insert → Chart**, replace the placeholder data in the worksheet, then use **Chart Elements**, **Chart Styles** and **Chart Filters** next to the chart to adjust it. For a lot of data or data that changes regularly, Microsoft suggests creating the chart in Excel and pasting it into the presentation.

Chart styles use the theme colors, so changing the theme recolors every chart, as Microsoft explains in its page on [changing the color or style of a chart](https://support.microsoft.com/en-us/office/change-the-color-or-style-of-a-chart-in-office-f4db3f23-f5a1-4b30-abb3-62e8c2c33d9b). To recolor a single chart, select it and choose **Chart Styles → Color**.

> **Tip: Set the theme colors before you build charts**
>
> Put your accent color in the first theme slot and a gray among the others on the slide master. Every chart then starts in your palette and a highlighted bar needs one click. The [slide master guide](https://ai-presentations.com/guides/slide-master/) shows where the theme colors live, and the guide to a [corporate design template](https://ai-presentations.com/guides/corporate-design-powerpoint-template/) covers the full palette.

## How does an AI tool handle charts?

Ask the AI for a chart, or mark an area and click "As chart". You can move, resize, duplicate or delete a chart by hand, and when the numbers change, you edit them in the editor or ask the AI for an update. The quality of the result depends on what you provide: the chart type, the values, the units, the periods and the source. A missing value should not silently become zero, so say what is missing.

Tables export to PowerPoint as tables with editable cells, so a table is easy to keep next to a chart when readers need exact values.

**Prompt: A chart that states the finding**

```text
Turn the table on page [number] into a [column / bar / line] chart. Use these values: [values with units and periods]. Source: [source]. Sort the bars from largest to smallest. Start the value axis at zero. Highlight [the one bar or line that matters] in the accent color and keep the others gray. Label the values directly instead of using a legend. Write the slide title as a full sentence that states the finding. If a value is missing, show it as missing and tell me, do not treat it as zero.
```

Treat the result as a first version and check every number against your source before the slide leaves your hands. The page on an [AI PowerPoint generator](https://ai-presentations.com/ai-powerpoint-generator/) explains the wider workflow, from the plan of pages to the export.

**Key takeaways**

- Choose the chart from the message: bars to compare, a line for change over time, a waterfall for a bridge, a table for exact values.
- Use a pie chart only for a few parts of one whole, following Microsoft's limits of one series, no negative values and no more than seven categories.
- Start bar axes at zero, sort by value, highlight one bar and write the slide title as the finding.
- Give an AI tool the chart type, values, units, periods and source, and check every number against your source before the slide leaves your hands.

## Frequently asked questions

### What is the best chart for a presentation?

There is no single best chart, only the best chart for one message. Use column or bar charts to compare categories, a line chart for change over time, a waterfall chart for how one value became another, a scatter plot for a relationship between two measures and a table when readers need exact values. Decide the message first, write it as the slide title, then pick the chart that shows exactly that.

### When should I use a bar chart instead of a line chart?

Use a bar or column chart to compare separate categories and a line chart for continuous data over time on an evenly spaced axis. Microsoft describes them the same way: columns for categories, bars for comparisons among individual items, lines for continuous data over time. With only a few periods, columns also work for time, and with long category labels horizontal bars are easier to read.

### When is a pie chart acceptable?

When you show a few parts of one whole and the point is roughly how big one part is. Microsoft's guidance for pie charts is one data series, no negative values, almost no zero values and no more than seven categories. If you need to compare slices precisely, use a sorted bar chart instead, because people judge position along a common scale more accurately than angles or areas.

### What chart shows how one number turned into another?

A waterfall chart, also called a bridge. It starts at one total, shows each increase and decrease as a floating bar and ends at the new total. It suits explanations such as how profit changed from one year to the next. Microsoft describes waterfall charts as showing a running total as values are added or subtracted.

### Should the axis of a bar chart start at zero?

Yes. The length of a bar is its value, so cutting the axis off above zero makes small differences look large. A line chart only shows the slope and position of points, so its axis can start higher if it is clearly labeled. If a bar chart needs a cut axis to show any difference, the difference is probably too small to be the message.

### How do I get a chart into my deck?

Ask the AI for a chart and give it the chart type, the values, the units, the periods and the source, or mark an area of a page and click As chart. You can move, resize, duplicate or delete the chart by hand. To change the numbers, edit them in the editor or ask the AI for an update. Tables export to PowerPoint as tables with editable cells.

## Related pages

- [Action titles](https://ai-presentations.com/guides/action-titles/): Write slide headlines as full sentences. Six rules for action titles, twelve before-and-after examples and a quick test you can run on any deck.
- [Waterfall chart](https://ai-presentations.com/glossary/waterfall-chart/): A waterfall chart shows how a start value becomes an end value through a series of increases and decreases. Definition, how to read it and typical mistakes.
- [Data-ink ratio](https://ai-presentations.com/glossary/data-ink-ratio/): The data-ink ratio is the share of a chart's ink that shows data, a concept from Edward Tufte. What it means, how to apply it and where it stops being useful.
- [Chartjunk](https://ai-presentations.com/glossary/chartjunk/): Chartjunk is decoration in a chart that does not help the reader understand the data, a term from Edward Tufte. Examples, the erase test and what research says.
- [Board presentation](https://ai-presentations.com/templates/board-presentation/): A board presentation template with the 8 slides a quarterly board meeting needs: summary, KPIs, revenue, EBITDA bridge, initiatives, risks and decisions.
- [Presentation rules](https://ai-presentations.com/guides/presentation-rules/): What the 10-20-30, 5-5-5 and 7-7-7 rules say, where each one helps, where it misleads and which are worth following in a work deck.

---

ai-presentations.com is published by Slaide (https://www.slaide.de), a sole proprietorship run by Nathalie Scholl in Heilbronn, Germany. [How this site is written, checked and corrected](https://ai-presentations.com/editorial-policy/).