Monday, 10 June 2013

How to Add Dynamic Values, Graphs in PowerPoint from MS Excel?

Description

While making PowerPoint presentations, you must face the need of adding values, tables or graphs. Well, here is the solution in this tutorial.

Solution:
Look at these steps to add charts and tables from Excel into a PowerPoint presentation:
1.       Select the table which you want to insert from the Excel sheet and press Control+C to copy
2.       After that, go to ppt and Home>Click on the arrow which will expand the Paste option to reveal the option “paste special”
3.       From the dialog box that appears, click the button says “Paste Link”
4.       In the “As” box, choose the option “Microsoft Office Excel Worksheet Object” and click “Ok”
5.       For changing data, you can change it in base excel and save it. This change will automatically occur in ppt.
For copying the chart, the steps are same as above except the fifth one. In fifth step, you need to select “Microsoft Office Excel Chart Object” for chart addition.

There are few limitations in dynamically linking ppt with XLS:
1.       While embedding the chart or table, make sure that the location of XLS will remain in the same position.
2.       In case, you need to mail the PowerPoint then send both ppt and Excel. Otherwise, the receiver will get a message “its linked to a file that unable to link” while opening it.

Hopefully, these steps will be helpful for you while preparing PowerPoint presentations. Now, give a more attractive and professional look to your PowerPoint presentation by adding charts, tables and graphs.

Congrats! You have successfully learned the various aspects of network security.  Hopefully, it would help you to protect your business against emerging e-threats and any unauthorized access. For more suggestions, contact our computer support helpdesk, as per below contact-details:
U.S. +855-859-0057
U.K. +800-635-0716
CA  1-855-749-5861
AU  1-800-197-298 

We would be more than happy to help you. We are available 24/7.

The Xpert Crew @ http://techvedic.com 



0 comments:

Post a Comment