Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Charts
Resolved · Low Priority · Version 2007
Hardeep has attended:
Excel VBA Intro Intermediate course
Can you take charts from excel to powerpoint with VBA?
Hello Hardeep
Thank you for your question.
If you want to insert an Excel chart into a PowerPoint slide and have it linked so that any changes made to the Excel chart are reflected in the PowerPoint slide you can use the Insert Object tool, to do this:
- create your chart in Excel, ensuring it is on the first worksheet & save the workbook.
- In PowerPoint open the Insert tab and select 'Object'
- select the 'Create from file' option & browse to the location of the Excel workbook.
- tick the 'Link' checkbox (if not ticked, the chart will embed itself on the slide.)
- to activate the chart within Excel, double click the chart on the Powerpoint slide, this will immediately open the Excel workbook
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Wed 29 Dec 2010: Automatically marked as resolved.
|
Excel tip:Display developer tab - Excel 2010a. In Excel, click on the File tab |
We'll call during UK business hours
Server loaded in 0.08 secs.