Skip to content
Tutorials Center
My learning

Topics

Lesson 19 of 40 Β· Images, Charts and Media

Charts in PowerPoint: Types, Data, Formatting and Storytelling

Create and format PowerPoint charts: choose the right chart type, edit the data sheet, set labels and axes, paste from Excel and highlight the message.

A chart is a sentence made of shapes: "sales grew faster in the south," or "three products make up most revenue." The skill is to pick the chart that says that sentence clearly and then remove everything that does not help. PowerPoint includes the same chart engine as Excel, so you get every standard chart type.

Insert a chart

  1. Insert > Chart (or the chart icon in a content placeholder).
  2. Choose a category on the left (Column, Line, Pie, Bar, Area, X Y Scatter, Map, Stock, Surface, Radar, Treemap, Sunburst, Histogram, Box & Whisker, Waterfall, Funnel, Combo) and a subtype.
  3. A small Excel sheet opens with sample data. Replace it with your own: the first row holds the series names and the first column holds the categories.
  4. Close the sheet. To edit again: Chart Design > Edit Data.

If the data already lives in Excel, copy the chart (or the range) and paste with Use Destination Theme & Embed Workbook (self-contained), Keep Source Formatting & Embed Workbook, or & Link Data (updates when the Excel file changes; the file must stay reachable).

Choose the right type

Which chart for which story

Column or bar Compare categories
Line Trends over time
Pie or doughnut Few parts of a whole
Scatter Relationship of two numbers

Start from the sentence you want the audience to say.

1 / 2
Goal Chart Notes
Compare a few categories Clustered column / bar Use bars when category names are long
Show change over time Line Use columns for few time points
Part of a whole Pie (max 5 slices), stacked column Sort slices; avoid 3-D
Distribution Histogram, Box & Whisker For analysts
Two numeric variables Scatter Add a trendline
Bridge from start to end Waterfall Great for finance
Two scales Combo (column + line, secondary axis) Label axes clearly

Format and simplify

Click the chart and use the three buttons beside it, or the Chart Design and Format tabs.

  • Chart Elements (+): Axes, Axis Titles, Chart Title, Data Labels, Data Table, Gridlines, Legend, Trendline. Prefer data labels and remove the legend and gridlines when you can label directly.
  • Chart Styles (brush): style gallery and color schemes. Single-color charts with one highlight color are stronger than rainbow ones.
  • Chart Filters (funnel): show or hide series and categories without deleting data.
  • Format Pane (right-click > Format): axis bounds, number format, gap width (narrow gaps for bars: 50-80 percent), series overlap, label position.
  • Axis: start the value axis at zero for columns and bars, or the visual size lies. For lines it may be reasonable to zoom in, but say so.

Replace the default chart title with a statement that says the finding: "South sales grew 24 percent". The audience reads the title first. Delete anything that does not serve it.

Highlight what matters

  1. Color all columns gray, then color the one column of interest with your accent color (click once to select the series, click again to select one point, then Shape Fill).
  2. Add a data label only to that point.
  3. Add an arrow or text box call-out for the cause.
  4. Animate the chart by series or category for step-by-step reveals (Animations > Effect Options > By Series; see animations).

Number formats and data labels

In Format Data Labels > Number choose Currency, Percentage or custom codes such as 0.0,"k" (thousands) or $#,##0. Labels longer than a few characters crowd small slices; use a legend or the call-out label option.

Accessibility

Provide Alt Text summarizing the main insight. Do not rely on color alone: add direct labels, or patterns for series that print in black and white. Avoid red/green pairs.

Try it: choose and sort data like a chart (stand-in)

PowerPoint charts come from an Excel sheet. This stand-in takes the same shape of data (categories and values), sorts it descending, computes shares and draws a text bar chart. It models the decisions you make in the chart, and is not PowerPoint.

JS Sorted bar chart from data (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Common mistakes

  • 3-D pies and shadows. They distort comparisons.
  • Truncated axes on bars: they exaggerate differences.
  • Too many series (over five lines) or slices (over five).
  • Rainbow colors with no meaning. Use one color plus gray.
  • Pasting a chart as a picture, which loses editability.

Check your understanding

Quick check Β· 4 questions

of 4 answered You scored / 4 Β· perfect!

  1. 1. Which chart is best for a trend over many months?

    Lines show direction and change over ordered time points.
  2. 2. Where do you edit the numbers behind a chart?

    Edit Data opens the embedded worksheet.
  3. 3. Why should column and bar charts start at zero?

    Bar length encodes the value, so a cut axis misleads.
  4. 4. What makes a better chart title?

    A finding-based title tells the audience what to see.

Summary

  • Insert a chart, then edit its data in the embedded sheet or paste from Excel.
  • Match chart type to the message: columns, lines, pies (few parts), scatter, waterfall.
  • Simplify: direct labels, one accent color, no 3-D, honest axes.
  • Use a title that states the finding and add alt text.

Next: Audio, Video and Screen Recording