Sometimes, you might want to import charts from Excel to PPT (PowerPoint presentation or slide). In such cases, you can follow this step-by-step guide to copy Excel charts to PowerPoint.
How to import charts from Excel to PPT
To import charts from Excel to PPT, follow any of these methods:
- Using direct copy-paste
- Using data copy-paste
- Using Paste link
- Using image.
1] Using direct copy-paste
It is the easiest and quickest method that you can use to import charts from Excel to PowerPoint. It is possible to migrate any chart from an Excel spreadsheet to a PowerPoint slide. For that, follow these steps:
- Open the Excel spreadsheet.
- Copy the chart. You can use Ctrl+C or, right-click on the chart and select Copy.
- Open the PowerPoint slide.
- Press Ctrl+V.
Disadvantage: The main disadvantage of this method is that the chart that is pasted is not self-updated. In other words, if you make a change in the Excel spreadsheet, it will not be reflected in the PowerPoint chart.
2] Using data copy-paste
This method is the best for those who want to send the presentation to someone and do not want to send the Excel file. Having said that, if you follow this method, you can create a self-dependent chart in PowerPoint. You can update data as per your requirements by opening PowerPoint and not Excel.
To import charts using this method, follow these steps:
- Open the Excel spreadsheet and copy the chart data.
- Open PowerPoint and go to the Insert tab.
- Select Chart.
- Select a type of chart you want to insert in your slide.
- Click the OK button.
- Paste the copied data in the spreadsheet-like window.
- Click the Close button.
Your chart will be visible immediately. Now, whenever you need to change something in your chart, right-click on it and select the Edit Data option.
Following that, you can edit the data as per your requirements.
3] Using Paste link
It is the oldest method of converting an Excel spreadsheet into PowerPoint. You can import any chart, image, graph, or other document to PowerPoint. The best part about this method is that the chart will be self-updating.
To import charts from Excel to PPT using the Paste link, follow these steps:
- Edit the Excel spreadsheet and save the file.
- Copy the chart from the Excel spreadsheet.
- Open PowerPoint and click on Paste > Paste Special.
- Select Paste link > Microsoft Excel Worksheet Object.
- Click the OK button.
Once you do that, your chart will be visible on the slide. For your information, if you double-click on the chart to edit, it will be the spreadsheet.
For your information, there is another shortcut that you can use to bypass all these steps. For that, you need to copy the data from the spreadsheet and open PowerPoint first.
Click on the Paste and choose the fourth option, Keep Source Formatting & Link Data.
4] Using image
It is another easy method to copy Excel charts to PowerPoint slides. In this method, you will learn how to save a chart as an image and insert it in your slide. If you want to follow this method, follow these steps:
- Right-click on the chart in the spreadsheet.
- Select the Save As Picture option.
- Select a path, set a name, and click the Save button.
- Open the presentation and create a new slide where you want to show the chart.
- Go to Insert > Pictures > This Device.
- Double-click on the saved picture.
However, if you do not want to go through all these steps and want to do it quickly, you can use Paste Options. First, copy the data and open the slide. Then, click Paste and select the last option, Picture.
That’s all!
Read: How to easily export Excel Charts as Images
How to copy from Excel to PowerPoint and keep formatting?
To copy Excel data to PowerPoint and keep formatting, you need to copy the data first. Then, open the PowerPoint slide and select the Paste option. Next, choose the second option that says Keep Source Formatting & Embed Workbook.
How to update charts in PowerPoint from Excel automatically?
To update charts in PowerPoint from Excel, you need to link the spreadsheet to PPT. For that, copy the data from Excel and open the PowerPoint slide. Select Paste > Paste Special. Then, choose the Paste link, and select the Microsoft Excel Worksheet Object option. Finally, click the OK button.
Leave a Reply