+ Reply to Thread
Results 1 to 2 of 2

Copy Excel Charts to PPT (Minimum 4 Charts on each PowerPoint Page)

  1. #1
    Forum Contributor
    Join Date
    02-04-2015
    Location
    India
    MS-Off Ver
    2010
    Posts
    133

    Copy Excel Charts to PPT (Minimum 4 Charts on each PowerPoint Page)

    Hey Excel Experts,

    Greetings !!

    I'm looking for a VBA code where I can paste excel charts into PowerPoint in image format.

    In a single page of PPT, at least 4 charts should get copied. I have total 9 different sheets (see attachment). From sheet 1 to 4, four charts should get copied to page 1 of PPT, from sheet 5 to 8, again four charts should get copied to page 2 of PPT and the last sheet i.e. 9th sheet - charts should copied to 3rd page of the PPT in center.

    In attachment I've add a sheet named as PPT Format, all the chart image can be in this format.

    Currently I do not any VBA code to share with you. Appreciate your support. Thanks !!

    Regards
    Attached Files Attached Files

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

    Re: Copy Excel Charts to PPT (Minimum 4 Charts on each PowerPoint Page)

    Here is a sample of how I do it. It involves a template workbook with everything except the charts filled in and then you tell the code where to look for the Excel Chart and on what page in the Powerpoint Presentation to put it and then where to position it and size it on the page.

    The attachment contains a sample workbook (that has all the code you need), a sample powerpoint and some documentation.
    Attached Files Attached Files
    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.

+ 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. Copy charts and/or Range (including chart) from Excel to Powerpoint
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2016, 12:35 AM
  2. Replies: 0
    Last Post: 01-14-2016, 05:18 AM
  3. Copy Image (not charts) from excel to powerpoint
    By Anum86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2015, 06:20 AM
  4. VBA to copy charts from excel to powerpoint
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2013, 11:20 AM
  5. Copy excel charts/graphs to Powerpoint with/without copying worksheet
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 09:05 AM
  6. [SOLVED] Copy Named charts in Excel to specific slide in Powerpoint
    By allstarrunner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2012, 09:10 AM
  7. Copy charts from excel to powerpoint template
    By Pana1 in forum Excel General
    Replies: 0
    Last Post: 07-13-2010, 05:38 AM

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