How to Insert a Chart into PowerPoint: A Clear Guide

To insert a chart in Microsoft PowerPoint for Microsoft 365 on Windows, open the slide, choose Insert > Chart, select a chart type, and click OK. Enter or replace the sample values in the worksheet that opens, then close it; the chart appears on your slide and remains editable. Before you start, decide what you want the chart to show and gather the data you plan to use.

What You’ll Need

A PowerPoint presentation and the slide where you want the chart.
Data arranged in simple rows or columns, with labels for categories and series. For example, put quarters in the first column and product names across the first row.
Microsoft 365 PowerPoint for Windows for the steps below. The Mac version has the same main Insert > Chart route, though the worksheet and ribbon layout can look different. Some editing controls in PowerPoint for the web may also differ; use the desktop app if a control described here is unavailable.

Step-by-Step

Choose the slide and make room. In Normal view, select the slide in the thumbnail pane. Decide whether the chart should replace a placeholder or sit beside text or an image. If the slide already has a content placeholder, click its chart icon if available. Otherwise, use the ribbon method in the next step. A chart needs enough space for its labels, legend, and title, so consider switching to a layout with less text before inserting it.
Open the chart picker. Select Insert > Chart on the ribbon. In the Insert Chart window, browse the chart categories on the left, such as Column, Line, Pie, Bar, or Combo. Select a specific design in the preview area and click OK. Choose a chart based on the comparison you need: columns work well for comparing categories, lines for change over time, and bars when category names are long. Avoid choosing a style only because it looks decorative.
Replace the sample data. PowerPoint opens a small Excel worksheet containing example labels and values. Select the cells with sample content and type or paste your own data into the corresponding rows and columns. Keep category labels in the first column and series names in the top row when the chart is arranged that way. For example, use Q1, Q2, Q3, and Q4 as categories, with separate columns for two products. The chart updates as you change the worksheet. Do not paste unrelated notes or totals into the chart range.
Check which cells the chart uses. The colored outline around the worksheet range shows the data included in the chart. Drag its lower-right corner to include additional rows or columns, or leave unused sample rows outside the outline. If the series and categories appear reversed, use the chart controls to change the orientation after closing the worksheet: select the chart, open Chart Design, and choose Switch Row/Column. This is useful when the data is correct but the chart groups it in an unhelpful way.
Close the worksheet and inspect the result. Close the worksheet window or return to PowerPoint; the chart is inserted on the slide. Closing the worksheet does not delete the data. Click outside the chart to see how it looks in the slide layout, then click the chart again to select it. Check that every category and series is represented and that the chart is not covering a title, footer, or other important content.
Add a useful title and labels. Click the chart title placeholder and enter a short title that explains the point of the graphic, not just the subject. To add or remove chart elements, select the chart and choose Chart Design > Add Chart Element. Depending on the chart type, you can add axis titles, data labels, a legend, or gridlines. Use data labels when readers need exact values; leave them off when they clutter the chart or repeat information already obvious from the axes.
Format the chart for readability. With the chart selected, use Chart Design to try a Quick Layout or change the chart colors. Use the Format tab for more detailed appearance controls. To change the scale or number format on an axis, right-click the axis and choose Format Axis. Keep text large enough to read at presentation size, use a restrained color palette, and make sure related series are easy to distinguish. Formatting should clarify comparisons rather than compete with the data.
Position and size the chart. Drag the chart from its border to move it. Drag a corner handle to resize it proportionally; avoid pulling a side handle if it makes the chart look stretched. Use the guides that appear to align it with other slide elements, and leave breathing room around labels and the title. Run Slide Show or use the presentation preview to check the chart at full-screen size, since small text that looks acceptable while editing may be difficult to read from a distance.
Save and verify the data stays editable. Save the presentation with Ctrl+S on Windows or Command+S on Mac. Click the chart and choose Chart Design > Edit Data to reopen its worksheet and confirm the values are present. If the chart is important, check it again after saving and reopening the file. A chart inserted directly in PowerPoint normally stores its workbook data with the presentation, so you can edit it without keeping a separate Excel file.

Common Mistakes

Using the wrong chart type: A pie chart with many categories is hard to compare, while a line chart can imply a continuous sequence where none exists. Match the chart to the question: are you comparing categories, showing a trend, or displaying parts of a whole? If the audience cannot identify the main comparison quickly, try another type.

Including extra or blank cells: A chart may show an empty category or unexpected series if its data range includes stray cells. In Edit Data, check the colored outline and remove unused rows or columns from the range. Also check that headings are in the intended header row and that values are actually numeric rather than text that looks like numbers.

Making the chart too busy: Too many series, labels, gridlines, or colors make the key information harder to find. Remove elements that do not help answer the slide’s main question. Do not rely on color alone to distinguish important groups; clear labels and consistent ordering help readers follow the chart.

Assuming an Excel link is the same as an embedded chart: A chart created with Insert > Chart keeps its data in the PowerPoint file. A chart pasted from Excel can instead be linked to an external workbook. Moving or renaming that workbook may break the link. Pick the paste option deliberately and keep linked source files accessible.

Tips

Organize the source data before creating the chart. Use one row for series names, one column for category labels, and avoid merged cells, blank spacer rows, and decorative formatting in the data range.
Use a descriptive title that states the takeaway, such as Quarterly Sales by Product, rather than a vague label such as Results. Keep the title factual and make sure the chart supports the claim.
For a consistent deck, use the presentation theme and a small set of colors. Apply the same color to the same product or group on different slides so viewers do not have to relearn the legend.
If you already have the chart in Excel, copy it and paste it into PowerPoint. On the Home tab, open the Paste options and choose an embedded option to keep the chart data in the presentation, a linked option to reflect changes in the workbook, or Picture when you need a fixed visual that will not be edited as a chart. The names and availability of paste options can vary by Office build.
For linked charts, keep the Excel workbook in a stable location and test the presentation on the computer where it will be shown. If you send the deck to someone else, include the source workbook or consider embedding the chart instead.
Use a simple example before pasting a large data table. Confirm the chart type, series order, and labels first, then add the full set of data. This makes it easier to spot whether the chart is interpreting rows and columns as intended.

Troubleshooting

The chart does not appear after clicking OK: Check whether it was inserted behind another object or outside the visible slide area. Open the Selection Pane from Home > Select > Selection Pane, if available in your ribbon layout, and look for the chart in the object list. You can also undo once, select the intended slide, and insert the chart again.

The chart shows sample values or the wrong data: Select the chart and choose Chart Design > Edit Data. Replace the sample entries and check the highlighted range. If the series are plotted in the wrong direction, choose Chart Design > Switch Row/Column. If some categories are missing, expand the data range to include them and confirm that the cells are inside the outline.

Labels or values are missing: Some chart types hide labels by default, and a chart may omit values stored as text. Select the chart and use Chart Design > Add Chart Element to add data labels or a legend where appropriate. In the worksheet, check that values are numeric and that category cells are not blank. If labels overlap, enlarge the chart, shorten the wording, or remove labels that are not essential.

The chart looks different on another computer: If it is linked, PowerPoint may not be able to find the source workbook. Open the file in the desktop app and look for an update or link prompt; restore the workbook to its original location or update the link to its new location. If the chart is embedded, confirm that the recipient can open the presentation in a compatible version of PowerPoint. For a final deck that must look identical and does not need editable data, paste a picture copy.

You cannot find a command shown here: Make sure the chart itself is selected; chart-specific tabs such as Chart Design appear only while it is selected. On Mac, the ribbon labels are broadly similar, but some commands or worksheet windows may be arranged differently. In PowerPoint for the web, open the presentation in the desktop app if the required chart editing control is not available.

Frequently Asked Questions

Can I insert an Excel chart into PowerPoint?

Yes. Copy the chart in Excel, select the PowerPoint slide, and paste it. Choose an embedded option to store editable chart data in the presentation, a linked option to use the workbook as its source, or Picture for a fixed image. Check the Paste options because the exact labels can vary.

Can I edit chart data after inserting it?

Yes. Select the chart and choose Chart Design > Edit Data. PowerPoint opens the chart’s worksheet so you can change labels or values. If you pasted a picture, it is not an editable chart; edit the original in Excel and paste a new copy.

Will the chart update automatically when Excel changes?

Only if the PowerPoint chart is linked to the Excel workbook and the link remains available. An embedded chart stores a copy of its data in the presentation and does not automatically follow later changes to a separate workbook. You can edit its embedded data in PowerPoint.

Which chart type should I choose?

Use columns or bars to compare categories, lines to show a trend over time, and a pie chart only for a small number of parts that add up to a meaningful whole. If the message is not clear at a glance, simplify the data or try a different chart type.

Can I insert a chart in PowerPoint for the web?

Chart support and editing controls can differ from the desktop app and may change over time. If you do not see the Insert > Chart option or cannot edit its data in the browser, open the presentation in PowerPoint for Microsoft 365 on Windows or Mac and make the change there.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.