Charts are one of the fastest ways to turn a slide full of numbers into a point your audience actually remembers. But PowerPoint’s charting tools work slightly differently depending on whether you’re on Windows or Mac, and most guides only cover one platform. This guide walks you through both, from inserting your first chart, choosing the right chart type, formatting it properly, and linking it to Excel so it updates automatically.
Adding a Chart in PowerPoint in 5 steps
On PC (Windows)
- Go to Insert > Chart on the ribbon.
- Pick a chart type and a specific style from the dialog box.
- A small Excel-style spreadsheet opens automatically alongside your slide.
- Type or paste your data into that spreadsheet.
- Close the spreadsheet window, and your chart updates on the slide immediately.
On Mac
The steps are almost identical, which is one of the few areas where PowerPoint for Mac and PC line up closely:
- Go to Insert > Chart in the ribbon (or Insert menu > Chart in older versions).
- Choose your chart type from the gallery.
- PowerPoint opens a linked Numbers-style or Excel worksheet where you enter your data.
- Close the worksheet, and the chart appears on your slide.
One practical difference worth knowing is that on Mac, the data window opens in a separate app window rather than docking beside the slide, so it’s easy to lose track of it behind other windows. Check your tab dock if it seems to have disappeared.
Picking the Right Chart Type
The chart type you choose matters more than any formatting decision you’ll make afterwards. Here are the 4 most popular to choose from;
- Column chart: best when comparing values across categories, especially changes over time (e.g., revenue by quarter). Vertical bars read naturally left-to-right, matching how most audiences scan a timeline.
- Bar chart: the horizontal version of a column chart. Use it when your category labels are long (product names, survey questions), since horizontal bars leave room for the full label without wrapping or shrinking the font.
- Line chart: best for showing trends over a continuous period, like monthly performance across a year. Avoid using more than four or five lines on one chart, or it turns into visual noise.
- Pie chart: only appropriate when your data represents parts of a single whole that add up to 100%. If your numbers don’t sum to a meaningful total, a pie chart will mislead more than it clarifies.
If you’re unsure which fits your data, a rough gut check works well: are you comparing amounts (column/bar), showing change over time (line), or showing proportions of a total (pie)? That question resolves most cases. If you are still unsure then you can reach out to our design team who would be happy to advise you.
This is also a good point to think about how many slides your chart-heavy deck actually needs. If you’re building out a longer report, our guide to slide count in presentations covers how to avoid overloading a deck with one chart per metric.
Editing and Formatting Your Chart
Once a chart is on the slide, PowerPoint gives you several ways to adjust it, and these menus are largely consistent across both PC and Mac.
Changing the underlying data
Click the chart, then open the Chart Design tab and select Edit Data. The spreadsheet reopens so you can revise numbers, add rows, or fix labels.
Changing the chart type
Right-click the chart and choose Change Chart Type, or use Chart Design > Change Chart Type on the ribbon. This is useful if you’ve built the chart and realise a bar chart would communicate the point better than the column chart you started with.
Adjusting chart elements
Click the small + icon that appears in the top-right corner of the chart when it’s selected. This opens a checklist where you can toggle axes, gridlines, data labels, and the legend on or off. Turning off elements you don’t need is often the single biggest improvement you can make to a cluttered chart.
Mac note:
The + icon and Chart Design tab both exist on Mac, though the exact position of some formatting panes (particularly the Format Chart Area sidebar) sits on the right of the screen rather than as a pop-out menu, depending on your version.
Automatically Updating Graphs By Linking Live Excel Data (Pro Tip)
If your chart’s source numbers are likely to change (a monthly sales figure, a running total, a live project metric) the good news is that you do not have to rebuild the chart every time. Instead automate it by doing the following;
- Build and format the chart in Excel first.
- Copy the chart (not just the data).
- In PowerPoint, use Paste Special and choose Keep Source Formatting & Link Data (or the “Link Data” paste option).
This creates a live link between the two files (Excel where the data is held and PowerPoint). When the Excel file updates, opening the PowerPoint file, or manually refreshing the link, pulls the new numbers through automatically. It’s especially useful for recurring reports, board decks, or dashboards you rebuild every month, since you only update the source spreadsheet once. The trade-off is that the link only works reliably if the Excel file stays in the same location; moving or renaming it can break the connection on both PC and Mac.
Charts built natively in PowerPoint also keep file size down compared with pasted images, which is worth knowing alongside our guide on how to compress photos and images in PowerPoint if your deck is carrying a lot of visual weight elsewhere.
Keep Your Charts Readable And Easy To Digest
Your chart will still fall short if it’s overloaded. Here’s what we would recommend to avoid that common pitfall;
- Limit your data points. Aim for 5-7 categories or series per chart. Beyond that, viewers can’t hold the comparison in their head, and the chart starts working against you rather than for you.
- Give the chart a conclusion as a title, not a label. For example”Q3 Revenue” tells the audience nothing; “Q3 Revenue Grew 18% Year-on-Year” tells them exactly what to take away, the same logic we cover in our guide to structuring a PowerPoint presentation for slide titles more broadly.
- Turn off unnecessary elements you don’t need. If every bar already has a data label, you probably don’t need a y-axis as well, since showing both is redundant and adds clutter.
- Stick to your presentation’s colour palette and keep it on brand. Charts inserted via PowerPoint’s tool inherit your theme colours automatically, which keeps them consistent with the rest of the deck, one more reason to use Insert > Chart rather than pasting a static image from Excel. For more on getting this kind of visual consistency right across a whole deck, see our tips on making your PowerPoint presentation look stunning.
Final Thought
The insert and format tools are genuinely very similar for both PC and Mac. Once you’ve built the chart, the real skill is choosing the right type, trimming it down to the data that matters, and titling it with the point you want your audience to leave with.
This matters most in the decks with the highest stakes. See our guide to corporate presentations for how well-chosen data fits into the bigger picture of a client-ready deck. And if you’re weighing up whether PowerPoint is even the right tool for the job, our comparison of Google Slides vs PowerPoint covers how charting capabilities differ between the two.
If you’d like a second pair of eyes on a deck before it goes in front of clients or stakeholders, that’s exactly the kind of polish we help with at Presentation Experts. To learn more about how we can help, contact us today!
