Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
charts

ResolvedVersion 2007

Hardeep has attended:
Excel VBA Intro Intermediate course

Charts

Can you take charts from excel to powerpoint with VBA?

RE: Charts

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

Will be marked as resolved in 5 days

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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.