To insert an Excel bar chart into PowerPoint, copy the chart in Excel, switch to your slide, and paste it. Choose a linked chart if you want it to update from the workbook, an embedded chart if you want its data stored in the presentation, or a picture if you only need a fixed image. Before you start, decide whether the chart should match Excel’s formatting or your PowerPoint theme.
What You’ll Need
- Microsoft Excel and PowerPoint for Microsoft 365 on Windows. The steps are similar in recent desktop versions.
- An Excel workbook with the chart you want, or a table of data from which you can create a chart.
- If you plan to link the chart, keep the workbook in a location PowerPoint can access, such as a stable shared folder. Moving or renaming it later can break the link.
Step-by-Step
- Prepare the source data. In Excel, check that the chart uses the intended labels and values. A simple layout has category names in one column and the corresponding numbers in the next, with headers in the first row. Remove unwanted blank rows or columns from the chart’s source range. If you already have a chart, click it and confirm that its title, axis labels, legend, and series are correct before copying.
- Create a bar chart if you do not already have one. Select the data, including its headers. On the ribbon, choose Insert > Insert Column or Bar Chart, then select a 2-D Bar option such as Clustered Bar. A bar chart displays categories along the vertical axis and values as horizontal bars; a column chart displays vertical bars. Pick the chart type that suits your data and the space available on the slide.
- Check the chart in Excel. Give it a clear title, make sure the value scale is sensible, and remove any series or categories that do not belong. If category labels are long, a horizontal bar chart can make them easier to read. Resize the chart in Excel if needed, but do not rely on its worksheet cell size to determine how it will fit on a PowerPoint slide.
- Copy the chart object. Click the chart’s outer border so the entire chart is selected, rather than selecting a bar, title, or individual chart element. Press Ctrl+C on Windows. If you see sizing handles around the chart frame, you have selected the chart. You can also right-click the chart border and choose Copy.
- Choose the destination slide. In PowerPoint, open the presentation and select the slide where the chart belongs. Consider whether the slide already has a title or content placeholder that the chart needs to fit around. Click a blank area of the slide, or the intended placeholder if you want the chart placed inside it, then press Ctrl+V.
- Select a paste format. After pasting, use the paste-options button that appears beside the chart. Choose Keep Source Formatting & Embed Workbook to retain Excel’s appearance while storing chart data in the presentation. Choose Use Destination Theme & Embed Workbook to adapt the appearance to the PowerPoint theme while keeping the data editable. The exact wording or icons can vary slightly by Office build.
- Decide whether the chart should stay connected to Excel. If you want PowerPoint to use the workbook as its data source, choose a paste option that says Link Data, such as Use Destination Theme & Link Data or Keep Source Formatting & Link Data. You can also open Home > Paste > Paste Special, select Microsoft Excel Chart Object, and select Paste link before confirming. Linking is useful when the workbook will continue to change; embedding is usually simpler when you want a self-contained presentation.
- Position and size the chart. Drag the chart by its outer edge to move it. Drag a corner handle to resize while preserving its proportions; avoid pulling a side handle if that would distort the chart. Leave enough room for the title, legend, labels, and any other slide content. Use PowerPoint’s alignment guides to line up the chart with nearby text or objects.
- Verify that the pasted chart behaves as intended. For an embedded or linked chart, select it and choose Chart Design > Edit Data to check that the data can be opened. Make a small test change only if appropriate, then undo it or close the data window without saving. For a picture, confirm that it is sharp at presentation size; it will not offer editable chart data.
Mac note: In Excel and PowerPoint for Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V. The paste choices and their labels can differ by Office version. Open PowerPoint’s paste menu or Edit > Paste Special where available, and check the chosen option’s description before pasting, especially if you need a live link.
Common Mistakes
- Copying only part of the chart. Selecting a bar or label before copying can result in an individual chart element instead of the complete chart. Click the chart border first and check that the full frame is selected.
- Choosing a picture when you need editable data. A picture is convenient and visually stable, but it cannot be edited as a chart or updated from the Excel workbook. Use an embedded or linked chart object if data editing matters.
- Linking to a workbook that will move. A link can stop working if the source file is renamed, moved, or unavailable to the person opening the presentation. Store both files in a dependable shared location and keep their relationship intact.
- Assuming the slide theme will preserve every design choice. A destination-theme paste may change colors, fonts, or other formatting. Review the pasted chart rather than assuming it will look exactly like the Excel version.
- Making the chart too small. Shrinking a chart to fit can make its labels unreadable. Simplify the categories, reduce nonessential chart elements, or give the chart more slide space instead.
Tips
- Choose the paste type based on how you will use the slide. Use a linked chart for recurring reports that should reflect workbook updates. Use an embedded chart when recipients need chart editing but should not depend on the original file. Use a picture for a final, unchanging visual or when editability is unnecessary.
- Keep the chart readable at presentation distance. Use a short title, legible category labels, and a clear value scale. If long category names make the chart crowded, widen it or shorten labels in the source data where appropriate.
- Check the slide in Slide Show view. A chart that looks clear while editing can become hard to read when projected. Review it at full-screen size and adjust the font size or chart dimensions if labels are difficult to see.
- Keep a copy of the source workbook. Even when the chart is embedded, retaining the workbook makes it easier to revise the underlying data later. For linked charts, make sure collaborators have permission to access the linked file.
- Use the same visual style across slides. If the deck has a defined theme, a destination-theme paste can help the chart fit in. If preserving Excel’s exact colors is more important, keep the source formatting and check that it still contrasts well with the slide background.
Troubleshooting
The chart appears as a still image. It may have been pasted using a picture option. If you still have the Excel chart, copy it again and choose an embedded or linked chart option. If you only have the picture, you cannot convert it back into its original editable chart data; return to the workbook or recreate the chart from the source data.
The chart does not update after the workbook changes. First check whether you pasted it as an embedded chart or a picture; neither is a live connection to the original workbook. If you chose Link Data, confirm the workbook is saved and accessible, then check PowerPoint’s link status under File > Info for Edit Links to Files when that command is available. If the source file was moved, restore it to its previous location or use the available link controls to reconnect it. Menu availability can vary by version and platform.
The chart looks different in PowerPoint. A destination-theme paste can alter colors and fonts. Try the source-formatting option if you need to preserve the Excel look, or adjust chart formatting in PowerPoint to match the deck. Also check for a slide background that reduces contrast and for text that has become too small after resizing.
The chart is cropped or overlaps other content. Select the outer chart frame and move it away from slide edges or neighboring objects. Resize from a corner, then inspect the full chart area, including the legend and axis labels. If the slide is too crowded, use a less detailed chart or place supporting details on another slide.
PowerPoint cannot find the linked workbook. Make sure the workbook has not been renamed or moved and that the person opening the deck can access its folder. When a dependable link is not practical, paste an embedded copy instead; it keeps chart data with the presentation, though updates in the separate workbook will not flow through automatically.
Frequently Asked Questions
Can I edit an Excel chart after inserting it into PowerPoint?
Yes, if you pasted it as an embedded or linked chart object. Select the chart and choose Chart Design > Edit Data to open its data. A picture paste is not editable as a chart.
What is the difference between linking and embedding?
An embedded chart keeps its chart data in the PowerPoint file, so it does not rely on the original workbook. A linked chart refers to the workbook and can reflect changes there, but PowerPoint needs access to the source file.
Will a linked chart update automatically?
It can update from its linked workbook, but PowerPoint may need to refresh the link or ask whether to update it when the presentation opens. The workbook must remain accessible, and link behavior can depend on Office settings and file location.
Can I change the chart colors to match my PowerPoint theme?
Yes. Choose a destination-theme paste option, or select the chart in PowerPoint and use the chart-design and formatting controls to adjust its appearance. Review the result to ensure labels and bars remain easy to distinguish.
Can I paste only the chart without its Excel worksheet?
Yes. Copy the chart object itself rather than selecting and copying the worksheet cells. Then choose a chart-object paste option. The embedded data belongs to the chart object; the full worksheet is not placed on the slide.
Does this work in PowerPoint for the web?
You can paste or insert content in PowerPoint for the web, but some advanced paste, link-management, or chart-editing options may be limited compared with the desktop app. For precise control over linked or embedded chart data, use the Microsoft 365 desktop apps.
Related
- Clear Email Address Cache in Outlook: Step-by-Step
- Clear Cache in Outlook for Windows 10: Step-by-Step
- Clear Cache in Outlook OWA: Browser Data and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pie Chart from a Single Column: What Works?Yes—but a single column works only when it contains numeric values you want to compare. Select the numbers,…
- How to Make a Chart in Excel: A Clear Step-by-Step GuideTo make a chart in Excel, arrange your information in labeled rows or columns, select the data, then…
- Excel Chart Conditional Formatting: Rules and WorkaroundsExcel charts do not automatically inherit conditional formatting from their source cells. To make chart colors respond to…
- 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…
- Box and Whisker Plot Excel X-Axis Labels ExplainedIn Excel for Microsoft 365 on Windows, box-and-whisker plot x-axis labels usually come from the headers above each…
- Excel Half Circle Chart: How to Create OneTo make a half-circle chart in Excel, create a doughnut chart with two visible values and a third…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.