Microsoft Excel and Microsoft PowerPoint continue to rule the market when it comes to tools for budgeting, long-term planning, and presenting them. For instance, accounting and finance experts at companies of all kinds need to insert Excel charts into PowerPoint. Nevertheless, we can present and understand data more clearly when we link or embed Excel charts into a PowerPoint presentation. In this article, we can learn how to pop an Excel chart into PowerPoint. With this in mind, use these 4 simple methods to insert an Excel chart into the PowerPoint given below.
Download Practice Workbook
You can download this workbook to practice yourself.
4 Simple Methods to Insert Excel Chart into PowerPoint
In this part, I will show you 4 simple ways to insert an Excel chart into PowerPoint. For instance, we have a dataset where column B mainly consists of Names of Branches and columns C & D consist of the Months and Sales report of a paper company respectively. Meanwhile, for this purpose of demonstration, I used Microsoft Excel 365. However, you can use any other version that is more convenient for you. I used the sample dataset listed below.
1. Apply Keyboard Shortcut to Insert Excel Chart into PowerPoint
Firstly, you can incorporate information from a stored Excel Worksheet into your PowerPoint presentation if you are using PowerPoint 2013 or a more recent version. Subsequently, this makes it easier to update the data in your PowerPoint presentation. We’ll use the keyboard shortcut technique to insert the Excel Chart into PowerPoint. In fact, you can copy and paste any chart you make in Excel into any Microsoft Office application. For instance, in this Excel dataset given below, we can see a monthly sales report of a paper company. Let’s go through 4 simple steps to insert an Excel chart into PowerPoint.
Steps:
- First, open your Excel workbook.
- Then, select the range B5:D8.
- In the same fashion, go to Insert > Chart > 2-D Column Chart.
- Subsequently, several chart format options will appear. To illustrate, let’s take a 2-D chart.
- As a result, the desired chart will appear.
- To begin with, right-click to select the chart that you want to embed into PowerPoint.
- Next, press Ctrl and C keys together to copy the chart.
- Subsequently, open your PowerPoint and simultaneously navigate through the slides where you wish to paste the chart.
- Again, press the Ctrl and V keys at the same time to paste the chart.
- Finally, you will get your desired result.
Read More: How to Update Charts in PowerPoint from Excel Automatically
2. Embed Excel Chart Through Insert Command in PowerPoint
Usually, Insert Command is a special tool of PowerPoint to add an Excel chart. For this method, we will use Insert Command to embed an Excel Chart as well.
Steps:
- Firstly, in the PowerPoint, Go to the Insert tab.
- After that, click or tap Object.
- Thereupon, a dialogue box will show up.
- Next, click Create From File.
- Further, open Browse.
- Consequently, in the browse box, find the excel workbook with the data you want to insert and link to.
- Last but not least, before you close the Insert Object box, click Link and then tap OK.
Read More: How to Embed an Excel File in PowerPoint (5 Easy Ways)
3. Insert Chart into PowerPoint with Paste Option
Charts give your PowerPoint presentation a little extra punch, instead of putting facts in bullet points. Most importantly, you can copy and paste into PowerPoint presentations using Excel charts with ease. Additionally, as updates are made to the original Excel data, update the charts in your PowerPoint presentation.
Steps:
- First and foremost, open the Excel workbook which has the chart you want.
- Secondly, select the chart.
- Further, on the Home tab, click Copy.
- Now, open the PowerPoint presentation.
- As well as, select the slide you want to insert the chart into.
- Here, you can click the Paste button to paste it.
- Moreover, you can tap the drop-down icon below Paste.
After that, you will find various paste options. Do one of the following,
- Select Use Destination Theme and Embed Workbook, to paste your chart into PowerPoint with the flexibility to alter it in PowerPoint and match the color scheme of your presentation.
- In order to be able to edit the chart in PowerPoint, tap Keep Source Formatting & Embed Workbook.
- Similarly, tap Use Destination Theme & Link Data to be able to edit it in Excel by making changes to your original data. The chart, on the other hand, will match the color scheme of your PowerPoint presentation.
- Also, click Keep Source Formatting & Link Data and make changes to your original data in Excel. The color scheme from Excel will be retained in the chart.
- In the same way, choose Picture to paste a picture of your chart into PowerPoint. The picture cannot be edited and is not tied to any data.
- Consequently, get your result in any format you wish.
Read More: How to Copy Table from Excel to Powerpoint with Formatting
4. Use Paste Special Feature for Inserting Excel Chart
All things considered, when it comes to presenting data, PowerPoint is the most popular option. Most frequently, people will copy and paste tables and charts from Excel before adding analysis within PowerPoint.
However, you will need to manually update all the tables and charts in PowerPoint when data in Excel changes (for instance, when you receive the new periods figure from your ERP system). Try to avoid making any mistakes. This is the point at which we link Excel charts into PowerPoint using the Paste Special Feature technique.
Steps:
- To begin with, open the PowerPoint presentation, and select the slide you wish to insert the chart into.
- Next, on the Home tab, click the arrow below Paste.
- Afterward, press Paste Special.
- As a result, the Paste Special dialog box will pop out.
- Thirdly, tap Paste Link.
- Lastly, but most importantly, click Microsoft Excel Worksheet Object or Microsoft Excel Chart Object if it is a chart.
- Press OK and you’ll get the desired chart in the PowerPoint.
- Thereupon, you get the desired result.
Read More: How to Open Existing PowerPoint File from Excel VBA
Conclusion
In conclusion, we have discussed here some easy ways to insert an Excel chart into Microsoft PowerPoint. Hopefully, you can now easily create the needed adjudgments. Our ExcelDemy website shows various simple problem-solving methods like this. Please feel free to leave any further queries or recommendations in the comment box below.