To insert an Excel chart into PowerPoint, select the chart’s outer border in Excel and press Ctrl+C, then open the slide and choose Home > Paste. Pick a paste option to control whether the chart keeps its Excel formatting, matches the PowerPoint theme, links to the workbook, or becomes a picture. Before you start, decide whether you need the chart to update when the Excel data changes; that choice affects which option is best.
What You’ll Need
- A chart in an Excel workbook, ideally with a clear title, readable labels, and the data series you want to show.
- Microsoft Excel and PowerPoint for Microsoft 365 on Windows for the steps below. Some paste-option labels and menus differ on Mac, as noted below.
- The source workbook saved somewhere you can find it. If you want a linked chart, keep that workbook accessible and avoid moving or renaming it after linking.
- A PowerPoint presentation with a slide selected for the chart. Save the presentation as a .pptx file to retain normal editing features.
Step-by-Step
- Prepare the chart in Excel. Open the workbook and click the chart once so that its border and sizing handles appear. If a chart is not made yet, select the data range, then use Insert and choose a chart type from the Charts group. Check that the chart includes the intended data and has a useful title. Resize it in Excel if you need to adjust the proportions, but leave enough room for the axis labels and legend. A chart that is clear in Excel may still need more space on a presentation slide.
- Copy the complete chart. Click the chart’s outside edge, not an individual bar, label, or plot area, and press Ctrl+C. Selecting the edge copies the chart as a single object. If you copy cells instead, PowerPoint may paste a table or a range of data rather than the chart. You can also right-click the chart’s border and choose Copy. Leave the Excel workbook open if you plan to link the chart or may need to revisit its data.
- Select the destination slide. Switch to PowerPoint and open the presentation. In the slide thumbnail pane, select the slide where the chart should go. Click the intended position on the slide if you want to set an insertion point; you can move the chart after pasting. To create a new slide, choose Home > New Slide and select a layout with enough space. Avoid placing the chart over a title or other content that must remain visible.
- Open the paste choices. On the PowerPoint ribbon, choose Home, then open the Paste drop-down arrow. The default Paste button may insert the chart immediately, but the drop-down lets you choose how it is stored. Depending on the Office build, PowerPoint may also display a small Paste Options button beside the chart after a normal paste. If you do not see the choices you need, undo the paste with Ctrl+Z and use Home > Paste > Paste Special.
- Choose how the chart should behave. Select a paste option based on whether editability, automatic updating, or appearance matters most. The common choices are described below. Exact wording can vary slightly by Office version, and not every option appears for every chart or clipboard state.
- Keep Source Formatting & Embed Workbook keeps the Excel chart’s styling and stores its underlying data inside the PowerPoint file. You can edit the chart and its data in PowerPoint, but changes made later to the original workbook do not automatically flow into the slide.
- Use Destination Theme & Embed Workbook adapts the chart’s colors and fonts to the PowerPoint theme and embeds its data. Choose this when the chart should look consistent with the deck and remain editable, without a live connection to the original file.
- Keep Source Formatting & Link Data keeps the Excel appearance and connects the chart to the source workbook. This is useful when you expect to update the workbook and want the slide chart to reflect those changes. The link depends on PowerPoint being able to find the workbook.
- Use Destination Theme & Link Data links to the workbook but uses the presentation’s theme for the chart’s appearance. Choose it when both future data updates and a consistent deck design matter.
- Picture inserts a static image. It is usually the safest choice when the chart only needs to look right and should not be edited or linked. It will not update when the workbook changes, and its chart data cannot be edited as an Excel chart.
- Place and size the chart. After choosing a format, drag the chart to the desired position. Use a corner sizing handle to resize it while keeping its proportions. Dragging a side handle can make the chart unusually wide or tall, which may distort its presentation. Make sure axis text, data labels, and the legend remain readable at slide-show size. If the labels are too small, enlarge the chart or simplify the chart in Excel rather than shrinking the rest of the slide text.
- Check editability and the link. For an embedded or linked Excel chart, select it and look for the Chart Design tab. Choosing Chart Design > Edit Data should open a data sheet for an editable chart; the exact editing experience can depend on the paste format. A picture will not show the same chart-editing controls. If you chose a linked option, save both files and confirm that the workbook is at the location PowerPoint expects. Close and reopen the presentation if necessary, then check that the chart still displays correctly.
- Save and verify the slide. Press Ctrl+S in PowerPoint. Review the slide in Slide Show view or use the presentation’s normal full-screen view to see whether the chart is readable from a distance. Check that the title, values, legend, and axis labels have not been clipped. If the presentation will be shared, test it on the computer or account that will open it, especially when the chart is linked to a separate workbook.
Mac note: The basic process is the same in Excel and PowerPoint for Mac: select the chart, copy it, and paste it onto the slide. Use the Command key instead of Ctrl for common shortcuts such as copy and undo. Paste Special is available through PowerPoint’s Edit menu in many Mac versions, but the names and number of link or embed options can differ from Windows. If the required choice is missing, use the paste options shown after pasting, or use the Windows desktop app for the Windows-specific ribbon paths above.
Common Mistakes
- Copying cells instead of the chart. This often happens when the chart’s edge is not selected. Confirm that handles surround the entire chart before copying.
- Choosing a picture when you need updates. A picture preserves appearance but is static. If the data will change, paste as a linked chart or embed the workbook data instead.
- Linking without planning for file access. A link can stop working when the workbook is moved, renamed, or unavailable to the person opening the presentation. Keep the workbook in a stable, shared location and send it with the deck when appropriate.
- Assuming an embedded chart stays connected to Excel. Embedding the workbook data makes the chart editable within PowerPoint, but it does not create a live connection to future edits in the original workbook.
- Making the chart too small. A chart may appear fine while editing but become hard to read in a room or on a small screen. Check it at presentation size and simplify crowded labels if needed.
- Changing the chart’s proportions. Pulling a side handle can stretch the chart and make its labels or plotted data look awkward. Resize from a corner and then reposition the chart.
Tips
- Choose the paste method based on the audience. For a deck that will be emailed without the workbook, an embedded chart or picture avoids reliance on an external file. For a working report that is refreshed regularly, a linked chart may be more useful.
- Keep a copy of the original workbook. Even if the chart is embedded, retain the source file as the clearest record of the full spreadsheet and its data. This is especially helpful if you later need to rebuild or substantially revise the chart.
- Use a clear chart title and restrained detail. A slide should communicate the main point quickly. Consider removing unnecessary gridlines or data labels in Excel before copying, rather than reducing the chart size to fit every detail.
- Use a picture only when appearance is the priority. A static image is less likely to change unexpectedly on another computer, but it cannot be refreshed as a chart. If crispness matters, use a high-quality picture option rather than taking a screen capture.
- Test linked files before sharing. Reopen the presentation from the location where it will be used. If recipients need to update the chart, give them access to the source workbook as well as the PowerPoint file.
- Keep chart and slide colors readable. A destination theme can change colors when pasted. Confirm that series remain distinct and that text has enough contrast against the slide background.
Troubleshooting
- The chart pastes as data or a table: Return to Excel, click the chart’s outside border until the full chart is selected, copy again, and paste into the slide. Do not start by selecting the worksheet cells behind the chart.
- The link option is missing: Make sure the chart itself is copied from the desktop Excel app, then use PowerPoint’s Paste drop-down or Home > Paste > Paste Special. Available options depend on the Office version, the copied object, and whether both apps are desktop apps. Excel for the web and PowerPoint for the web may not offer the same paste controls as Microsoft 365 desktop apps.
- The chart does not update after editing Excel: Check whether you chose a linked rather than embedded or picture option. Save the workbook first, then reopen or refresh the presentation’s connection if prompted. In PowerPoint for Windows, linked-file controls may be available under File > Info > Edit Links to Files; availability depends on the file and Office build. If no link exists, paste the chart again using a Link Data option.
- PowerPoint says it cannot find the workbook: Restore the workbook to its original location or use the link-management options to change the source, if available. If the file has been moved or the audience cannot access it, replace the linked chart with an embedded chart so the data travels with the deck, or use a picture if edits are not needed.
- Formatting changes after pasting: Undo, paste again, and choose Keep Source Formatting if you want the Excel design, or Use Destination Theme if the presentation’s colors should take precedence. Review fonts, labels, and chart colors after the choice; the destination theme can alter the appearance.
- Labels or the legend are cut off: Increase the chart’s size using a corner handle, move it away from the slide edge, or return to Excel and shorten labels or adjust the chart layout. Do not cover the missing text with a separate shape unless you are deliberately creating a static design.
Frequently Asked Questions
Can I edit an Excel chart after inserting it in PowerPoint?
Yes, if you insert it as an editable chart with embedded or linked workbook data. Select it and use Chart Design > Edit Data when available. A picture is not an editable chart.
What is the difference between linking and embedding?
A linked chart refers to data in an external Excel workbook and can reflect changes to that source, provided the link remains accessible. An embedded chart carries its data inside the presentation and can be edited there, but does not automatically track later changes to the original workbook.
How do I keep the Excel chart’s original colors and fonts?
Choose Keep Source Formatting in PowerPoint’s paste options. If you choose Use Destination Theme, PowerPoint may adapt the chart’s colors and fonts to the presentation theme.
Can I insert an Excel chart in PowerPoint without linking the workbook?
Yes. Choose an option that says Embed Workbook to store editable chart data in the presentation, or choose Picture for a static image. Neither option depends on a live link to the original workbook.
Can I insert a chart using Excel and PowerPoint online?
You can copy and paste content between the web apps, but their paste and link choices may be more limited than in the desktop versions. If you need a specific linked or embedded format, use Excel and PowerPoint for Microsoft 365 on Windows or check the available Mac desktop options.
Related
- Find the Financial Year From a Date in Excel Easily
- How to Find Errors in Excel: A Practical Workbook Guide
- How to Find Exact Duplicate Names in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Agile Gantt Chart in Excel: Plan Sprints and ReleasesYes. You can make an Agile Gantt chart in Microsoft Excel by listing work items, adding start and…
- Add Data Labels to a Google Sheets Chart: Steps & TipsTo add data labels in Google Sheets, select the chart, open the chart editor, choose Customize > Series,…
- Excel Pivot Table Row Limit: What You Need to KnowIn Excel for Microsoft 365 on Windows, a PivotTable displayed on a worksheet is limited by the worksheet…
- 24-Hour Gantt Chart Excel: 24 Setup Ideas That WorkTo make a 24-hour Gantt chart in Excel, put 24 hourly time values across the columns, list tasks…
- Power Pivot Add-In: What It Does and How to Enable ItThe Power Pivot add-in is an Excel tool for building data models: it can connect tables, define relationships,…
- Excel Pivot Table Filter: Less Than an Amount?To filter a PivotTable to amounts less than a threshold in Excel for Microsoft 365 on Windows, open…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.