How to Make a Chart in PowerPoint

Inserting the chart takes fifteen seconds. Making it readable on a projector takes five minutes, and keeping it right next month is the part nobody plans for.

The quick answer: Insert → Chart, pick a type, and replace the sample data in the grid that opens. That is the mechanics. The rest of this is the two things that decide whether the slide works — formatting for a room rather than a screen, and what happens to the chart next month.

Insert the chart

Two routes to the same dialog. Go to Insert → Chart, or click the small chart icon inside a content placeholder on a layout that has one. The second is better: the chart lands in the placeholder, so it inherits your template's position and size instead of appearing in the middle of the slide for you to drag around.

Choose a type and click OK. A small spreadsheet grid opens above the slide, filled with sample data.

The detail that catches people out: the live range is the shaded area with a blue handle at its bottom-right corner. Drag that handle to take in more rows or columns. Values typed outside it are ignored and the chart simply will not show them — no error, no warning.

Close the grid when you are done. The chart stays on the slide, and its data is stored inside the .pptx.

Bringing a chart over from Excel

If the chart already exists in a workbook, build it there — Excel is better at charts and always will be. Copy it, then on the slide use the paste options. Five choices appear; in practice there are three decisions:

• Use Destination Theme & Embed Workbook — restyled to your deck's colours, data carried inside the file. The usual right answer.
• Keep Source Formatting & Link Data — keeps the Excel look and leaves the data in the workbook, so the chart can be refreshed later.
• Picture — a flat image. Nothing to break, nothing to update, and no way back.

Linking is the one to think about. A linked chart can be brought current with Chart Design → Refresh Data, and PowerPoint offers to update links when the file opens. But the link is a path to a file on your machine: send the deck to anyone else, or move the workbook, and what they see is the last saved picture while you see a live one.

Choosing the chart type

On a slide, this matters more than in a report, because the audience gets one look at it.

Formatting for a room, not a monitor

Nearly every default PowerPoint chart is designed for someone sitting two feet from a screen. A few changes fix most of it:

• Turn data labels on and gridlines off. Nobody in the third row is measuring against an axis. Give them the number.
• Delete the legend when there is one series. It is restating the title.
• Put the point in the title. "Revenue by Month" describes the chart. "Revenue grew every month except March" is the reason the slide exists.
• Colour one series, grey the rest. If the argument is about one product line, the other five should recede.
• Resize from a corner so the proportions hold, and widen before shrinking the font when labels crowd.

The monthly deck problem

Everything above assumes you are making the chart once. A deck you present every month is a different job, and it is where the time actually goes: export the new data, rebuild or re-chart, paste, line it up, then re-read every slide to find the sentence that still quotes last month's number.

Charts pasted as pictures cannot be updated at all. Charts created in PowerPoint need their grid re-entered by hand. Linked charts can be refreshed — but only the charts. The takeaway text beside them has no link and no refresh, and that text is what the room reads first.

Having the deck ask for its own charts

Quiriz for PowerPoint is built for that second job. Rather than making the chart, you ask for it: type a question such as net sales by month and press New slide, and the add-in adds a slide after the current one with a headline in its title and the answer across the content area — in your template's own layout, in the deck's theme colours.

A whole deck works the same way. Pick the data, say what the deck is for, and Quiriz plans it and shows you the plan before it builds anything: each slide's title, the question it will ask, and whether it will show a chart, a table or text. Edit the titles, untick the slides you do not want, add one of your own, then press Build. Each chart arrives with two to four takeaways beside it, written from that chart's own figures.

You can also write the questions into your template — =QUIRIZ.ASK("net sales by month") on a slide, with "table", "both", "figure" or "notes" as an optional second argument — and press Build from markers. A marker that is the only text in a placeholder is answered inside that placeholder, so your layout decides where each chart lands.

Restyling is spoken rather than clicked: press Change on a chart and say dark blue, or a line instead of bars, or the latest month in green. The chart redraws where it is, and the style travels with it through every later refresh.

Then the month after: every chart, table, figure and note keeps its question on the shape, so Refresh all asks them all again and redraws each object where you left it. Totals, charts and takeaways move together from the same data, so no slide is left behind on last month's number.

Worth knowing before you install: it works in PowerPoint 2021 and later on Windows and Mac, and in PowerPoint on the web. On perpetual PowerPoint 2021 and 2024 a new slide is added at the end of the deck rather than after the current one, and real PowerPoint tables need Microsoft 365 version 2504 or later, or the web.

Where it does not apply. A single chart of eight numbers for one meeting is Insert → Chart, and nothing is going to beat that.

Frequently asked questions