98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Powerpoint - Charts - pasting and add-ins | PowerPoint forum
Powerpoint - Charts - pasting and add-ins | PowerPoint forum
Resolved · Medium Priority · Version 2010
Thu 14 Mar 2013, 10:37Delegate Vik said...
Vik has attended:
Excel VBA Intro Intermediate course
Powerpoint - Charts - pasting and add-ins
1. In Powerpoint I want to paste in a chart from excel which can be edited (i.e. is not a picture) but which is not linked to the excel source file. So when the graph changes in excel the graph does not change. Suprisingly when pasting as a "MS Graphics Object" the chart is still linked and if the graph data changes in Excel the Powerpoint graph also changes.
2. Could you suggest the best add-in's for Powerpoint / Excel for charting? For example, SSRS has guages etc which Powerpoint / Excel seems to lack.
Thu 14 Mar 2013, 15:38Trainer Andrew said...
RE: Powerpoint - Charts - pasting and add-ins
Hi Vik
Thank you for your questions.
Regarding the linking - when you paste the chart into PowerPoint look to the outside of the lower right corner of the chart. There will be an icon of a clipboard. If you click this icon the first two paste options embed the workbook (ie the Excel data is stored in the presentation but is not linked to your original file).
Once you have chosen this option close and save Excel.
Save PowerPoint.
Now you should find there is no link between them, even if you re-open and edit the original Excel file.
I don't have experience of other charting options but you may find sparklines (Insert Ribbon then Sparklines group > Line) interesting. We have an article on the subject here:
https://www.stl-training.co.uk/article-1873-what-are-sparklines-in-excel-2010.html
I hope this helps, do let us know if you have any further questions.
Kind regards,
Andrew
Mon 25 Mar 2013, 10:33Delegate Vik said...
RE: Powerpoint - Charts - pasting and add-ins
Thanks for the response Andrew.
Is there any other way to paste in a chart without links but still edit it? I ask as I did not want to embed the whole work book for every graph.
Re excel graph add in's Simon mentioned he may have a few suggestions?
Mon 25 Mar 2013, 15:06Trainer Andrew said...
RE: Powerpoint - Charts - pasting and add-ins
Hi Vik
Thanks for getting back to me. Embed is the only option that I can think of.
To avoid lots of sheets being embedded into your presentation you could (in Excel) right click the tab that contains your source sheet and chart. Choose Move or Copy from the menu that appears. Tick create a copy and choose a new workbook as the destination.
When you click on OK you will have a one tab workbook along with your chart.
Copy and paste this chart into your presentation. PowerPoint will embed the workbook only now it will only be a one page workbook.
Let me know if this helps.
Kind regards,
Andrew
Thu 21 Mar 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
PowerPoint tip:Hide Pointer in Slide ShowShow or Hide the Arrow pointer during a presentation press A on the keyboard |
