+ Reply to Thread
Results 1 to 3 of 3

Add graphs from excel workbooks to powerpoint

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Add graphs from excel workbooks to powerpoint

    So I have lets say 3 workbooks and on each first tab of that worbook there is a (pivot)graph.
    Now what I would want is VBA code which opens these excel workbooks, then copy the chart and paste it into a powerpoint presentation each chart on a new powerpoint slide.

    So it can be rather basic. A loop which goes thru excel sheets and always takes the chart on the first tab.

    I see a lot of different code but not what I really can use for powerpoint thru excel vba.
    Thanks.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Add graphs from excel workbooks to powerpoint

    Why not link the charts and not use VBA at all?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Re: Add graphs from excel workbooks to powerpoint

    Thanks for tip, but I am not a big fan of external linking.
    Also the main goal of the VBA is not making the powerpoint but generating workbooks by division with charts.
    I thought adding a button to generated also powerpoint slides to use in a presentation would be nice to have .

+ 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. [SOLVED] Excel macro to export Graphs to Powerpoint
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2013, 02:16 AM
  2. [SOLVED] Auto generate graphs in excel and copy them to powerpoint
    By aashr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 12:49 PM
  3. [SOLVED] Moving graphs from excel to powerpoint issues
    By edoptx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2012, 03:18 PM
  4. Replies: 4
    Last Post: 08-08-2011, 10:20 AM
  5. [SOLVED] Excel graphs in PowerPoint
    By Meghen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-20-2006, 11:40 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