Board logo

subject: How To Embed Excel Charts Into Powerpoint [print this page]


To convince a client or colleagues, there is nothing better that a solid report or presentation . For this, it is often necessary to embed charts and graphs either regarding the statistics or any data related to the presentation. These charts help you ease up the demonstration process..

PowerPoint and Excel are two good tools to design these graphics. For the beginners, Designing a chart with PowerPoint isn"t a child"s play and you might end up messingHow to Import Excel Charts into PowerPoint

To convince a client or colleagues, there is nothing better that a solid report or presentation . For this, it is often necessary to embed charts and graphs either regarding the statistics or any data related to the presentation. These charts help you ease up the demonstration process.

PowerPoint and Excel are two good tools to design these graphics. For the beginners, Designing a chart with PowerPoint isn"t a child"s play and you might end up messing it up. While on the other hand, Excel, tool, solely creating for handling data is a much easier solutions for charts. Here"s how you can import Excel Charts into a PowerPoint Presentation

You can either choose to embed or link the chart onto your current PowerPoint presentation. Embedding implies the data is managed independently in the .PPT file and have no correlation with the original excel stylesheets. Coming to linking, it creates a bridge between the excel data and the PowerPoint file. When the data in excel sheet is modified, the corresponding data in the carts also gets updated

How to Embed Excel Charts

1. Run PowerPoint, Open your existing presentation or create a blank file.

2. Highlight the slide, in which you wish to embed or link the chart in. On the ribbon, browse to the insert tab. Click on Insert -> Object. Click on the "New" button

3. Select Microsoft Office Excel Chart from the drop down and hit O

4.You can either create new or import an existing excel chart. Choose "Create from File" Radio button and browse for the excel file you wish to embed the chart from, and click OK

5. If you want to link the file instead of embedding, just click the Link Box in this window and proceed.

Embedding vs Linking

The concept of linking and embedding might lead up to another debate, which one to choose? Embedding will increase the size of the .PPT file.

If you are planning on linking, you will need to include excel file in the folder which might make it uncomfortable to share or move your presentation to another PC. But it gives an intuitive way to easily modify data. It would be great for integration real-time statistics. If the data of your company (Sales, Turnover e.t.c) are dynamically stored in an excel file, you can display statistics in real time.

by: Jane Lee




welcome to loan (http://www.yloan.com/) Powered by Discuz! 5.5.0