+ Reply to Thread
Results 1 to 4 of 4

Paste Excel Chart into PowerPoint

Hybrid View

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Washington DC
    MS-Off Ver
    Excel
    Posts
    13

    Paste Excel Chart into PowerPoint

    Hello - I am not too familiar with VBA and needed help writing a code that will paste 4 of my charts from Excel into an existing PowerPoint.

    I have 4 charts that need to be pasted on the following slides-

    Chart 1 - slide 11
    Chart 2 - slide 15
    Chart 3 - slide 17
    Chart 4 - slide 19

    Can anyone please help point me in the right direction?

    I've gotten to the point where I can open the Presentation, but having trouble getting the code to be able to paste the charts.

    Any help would be greatly appreciated!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Paste Excel Chart into PowerPoint

    See if this helps: https://www.excelforum.com/tips-and-...rom-excel.html.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    Washington DC
    MS-Off Ver
    Excel
    Posts
    13

    Re: Paste Excel Chart into PowerPoint

    I greatly appreciate the help and this has me on the right track.

    I am getting an error on the line:
     Set sh = Sheets(cl.Value)       ' Excel Sheet
    I see the same comment on the thread you directed me to, but am unsure of how to fix this.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Paste Excel Chart into PowerPoint

    If you want to change text on the PowerPoint sheet, then the code will ignore this line.

    However, if you are attempting to put in an Excel Chart or Range then you need to make sure that the sheet names in the "map" table match the sheet names in the Excel Workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  2. Paste Excel Chart into Powerpoint placeholder
    By jsunnb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2014, 01:53 PM
  3. Excel chart to paste it on powerpoint file
    By albert28 in forum Excel General
    Replies: 0
    Last Post: 04-21-2014, 03:45 AM
  4. Paste chart as jpeg/png into powerpoint
    By rishadjb in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-18-2013, 09:09 AM
  5. Replies: 4
    Last Post: 02-01-2013, 12:00 PM
  6. Replies: 0
    Last Post: 12-02-2011, 12:06 PM
  7. Replies: 2
    Last Post: 03-18-2006, 02:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1