charts

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Charts

Charts

resolvedResolved · Low Priority · Version 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.


 

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.07 secs.