A report can hold every number; a slide cannot. The common mistake in presenting data is to paste the report’s chart — twelve series, a legend, small labels — and expect the audience to find the point. They will not have time. A data slide works when the point is written in its title and the chart shows only what proves it.
Start with the point, not the chart
Before you choose a chart, write the sentence the data should prove: “Online sales overtook stores in March.” “Region North missed the target by 8 %.” “Costs per order halved in two years.” That sentence becomes the slide title, and it tells you which comparison the chart must show.
Most points are one of five comparisons. Each has a chart that shows it best:
| Your point compares … | Use | Avoid |
|---|---|---|
| values of categories (regions, products) | Bar or column chart, sorted | Pie with many slices, 3D bars |
| change over time | Line chart (many points) or columns (few) | Pie, area with many series |
| parts of one whole | Pie or donut with two to four parts, or a stacked bar | Pie with tiny slices |
| the steps from one total to another | Waterfall chart | Separate bars without connection |
| stages that narrow down | Funnel chart | A table of percentages |
| two measures for many items | Scatter chart | Two separate charts |
| exact values to look up | Table | A chart with every value labelled |
Build a chart in PowerPoint
Insert and fill a chartWindows and Mac
Insert the chart
On a Title Only slide choose Insert → Chart, pick a type (for example Column → Clustered Column) and click OK. On a Mac, Insert → Chart opens a menu of types directly.
Insert → Chart Enter or paste the data
A worksheet opens with sample data. Paste your figures over it, and drag the blue range border so it covers exactly your rows and columns. Close the worksheet; Chart Design → Edit Data opens it again.
The chart’s worksheet with data pasted Sort the bars
Sort categories by value in the worksheet (largest first), unless they have a natural order such as months.
Write the point as the title
Put the point into the slide’s title and delete the chart’s own title (Chart Elements, the + button beside the chart, untick Chart Title), so there is one headline, not two.
To reuse a chart from Excel, copy it there and paste it into PowerPoint; the paste options offer Use Destination Theme & Embed Workbook (a copy that travels with the file) or Link Data (it updates when the Excel file changes, but breaks if the file moves).
Clean the chart: remove, then highlight
Default charts carry more ink than they need. Remove everything that does not help the point, then make the point stand out.
Declutter and highlightWindows and Mac
Remove gridlines and the legend
Click the + (Chart Elements) beside the chart, or Chart Design → Add Chart Element on a Mac, and untick Gridlines and Legend. Label series directly with Data Labels or a text box instead of a legend.
Chart Elements: Gridlines and Legend unticked Grey everything
Select the series and set Format → Shape Fill to a light grey.
Colour the bar that matters
Click the series once, then the single bar again to select only it, and give it the accent colour. That is where the eye goes.
One bar highlighted in the accent colour Label what you talk about
Add a data label only to the highlighted bar (right-click → Add Data Label) or write an annotation in a text box with an arrow.
- Start bar axes at zero. A truncated axis makes small differences look huge; line charts may start elsewhere if you say so.
- No 3D. Perspective distorts the values it shows.
- Round the numbers to what matters: “2.4 m”, not “2,413,877”.
- Name the source in small text at the bottom: the audience trusts data it can trace.
Pie charts done right
Pie charts are criticised because eyes judge angles badly; comparing two similar slices is guesswork. They still have a place: showing that one part is a big or small share of a whole. Use them when there are two to four parts, the parts add to 100 %, and one share is the point.
Create a pie chart in PowerPointWindows and Mac
Insert it
Choose Insert → Chart → Pie (or Doughnut) and enter the categories and their values in the worksheet. Order the slices largest first; PowerPoint starts at twelve o’clock and runs clockwise.
Insert Chart → Pie Label the slices
Under Chart Elements → Data Labels → More Options, tick Category Name and Percentage and choose Outside End or Best Fit. Delete the legend.
Pull out the slice you discuss
Click the pie, then the one slice, and drag it outward a little — or set Point Explosion in Format Data Point. Give it the accent colour and the rest greys.
If you have more than four parts, group the small ones into “Other”, or use a sorted horizontal bar chart instead — it shows the same shares more precisely.
Statistics slides: numbers that stick
Sometimes the data is a handful of key figures — growth, customers, satisfaction, savings. A statistics slide (often called a KPI or key-figures slide) shows three or four of them large, each with a short label and, where useful, a comparison.
- Three or four figures per slide. More becomes a table.
- Each figure with context: “+18 % vs last year”, “4.6 / 5 from 1,200 ratings”.
- Same format for all: the same number of decimals, the same unit placement.
- Icons only if they add meaning, not as decoration.
Consultants’ statistics slides add one more line: a short takeaway under the figures saying what they mean together. That line is often what the client remembers.
Data in Google Slides
In Google Slides, Insert → Chart offers bar, column, line and pie charts, or From Sheets to insert a chart from a Google Sheet. The chart stays linked: when the sheet changes, an Update button appears on the chart. To edit it, click the chart’s menu and choose Open source; all formatting happens in Sheets.
When a table beats a chart
Charts show patterns; tables show values. If the audience needs to look up exact figures — prices, specifications, a budget by line — a well-made table is the right choice. Keep it to five to seven rows and four or five columns, right-align numbers so their digits line up, use the same number of decimals per column, and highlight the row or cell you talk about with a light fill. Remove vertical lines and keep thin horizontal ones; the table reads faster.
A useful hybrid is a table with a small bar in one column, drawn as a shape or built with a bar chart beside the table. It keeps the exact values and adds the visual comparison. Our guide to table borders and colours shows the formatting steps.
Designs for this kind of deck
Every design brings its own colours, fonts and layouts to the whole deck.
Charts and data in ExpertSlides
ExpertSlides has nine chart kinds — columns, horizontal and stacked bars, lines straight or smooth, areas, pie, donut and funnel — and tables, as one family: Change chart type turns one into another in place, a table included. Charts take their colours from the deck, so they always match. The Data tab shows the figures as a flat table to edit, and Upload your chart data replaces them from a file. In the Insert tab, Upload Data puts a spreadsheet or CSV on a new slide as the chart or table it is.
On a selected chart, drag the end of a bar or the point of a line to change that value, pull a slice out of a pie, and give a single bar its own colour from the chart’s toolbar — the highlight technique above in two clicks. When the AI builds a deck from your documents, it turns their figures into charts and key-number slides without inventing values. In the PowerPoint export (Pro and Business) charts become real PowerPoint charts with their workbook, so Edit Data works.
For the deck around your data, read business presentations and the guide to planning slides; for tables, table borders in PowerPoint. Browse designs in Design Templates.
Questions, answered
What is the best way to present data in PowerPoint?
Write the point as the slide title, choose the chart that shows that comparison (bars for categories, lines for time, pie for a share of a whole), remove gridlines and legends, grey the rest and highlight the one value you talk about.
How do I create a pie chart in PowerPoint?
Choose Insert, Chart, Pie, enter categories and values in the worksheet, add data labels with category name and percentage, and delete the legend. Keep it to two to four slices.
When should I not use a pie chart?
When there are more than four or five parts, when the parts are similar in size, or when you compare values over time. Use a sorted bar chart or a line chart instead.
How do I link an Excel chart to PowerPoint?
Copy the chart in Excel and paste it into PowerPoint with the paste option Use Destination Theme and Link Data. It updates when the Excel file changes, as long as the file stays where it was.
Does ExpertSlides make editable charts?
Yes. Its charts have their data in the Data tab, and on the plans with PowerPoint export they become real PowerPoint charts with their workbook, so Edit Data works.
