+ Reply to Thread
Results 1 to 6 of 6

How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

    Hello Forum

    I have the attached 4 graphs. They are different in sizes.

    I wanted to copy and paste these 4 graphs into a single PowerPoint slide so that one quadrant of the PPT slide has one graph. And each graph should be looking identical in size in PPT slide.

    What I have done:

    Highlighted one graph in Excel, right clicked, pressed “copy”
    Then I have gone to PPT slide, clicked “home’, selected “paste special” under “paste”, selected “Picture (Windows Metafile)” and pasted as a picture (this is necessary to avoid file being heavy).


    Then followed the same procedure for the remaining 3 graphs.

    Then manually re-sized the 4 graphs in PPT so that each graph is nicely and evenly distributed across 4 quadrants in the PPT slide.

    Q:
    This manual re-sizing is very tedious and time consuming.
    Would there be any other automated way to copy and paste 4 graphs into PPT slide.

    Thanks
    Mirisa
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

    Hi Mirisa,

    I have this tool called PUP7 that allows sizing and aligning of Objects on a sheet. I used it to do what I think you want. There is most likely other ways to do this but I like PUP7.

    http://spreadsheetpage.com/index.php/pupv7/home
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

    1. Make the Excel charts the right size, so after pasting them in PowerPoint you don't need to resize them.

    2. Show the PowerPoint gridlines at the vertical and horizontal center of the slide. Paste the charts, then align them with these gridlines. It is then a simple matter if you want to select one or more of the charts, and move them on the slide with the arrow keys (if you want them a bit further apart, or lower to allow more room for the slide title, etc.).
    .
    Jon Peltier
    http://PeltierTech.com/

  4. #4
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

    Hi Marvin and Jon,
    Thanks to both of you for this contribution.

    Hi Marvin,
    My working place doesn't allow to download any software though.

    Thanks again to both of you
    Mirisa

  5. #5
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

    Hold down the Alt key while moving and resizing charts. This will cause the edges of the chart to align with the cell boundaries, making it easy to align charts and make their sizes consistent.

  6. #6
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?

    Hi Jon,
    Thank you very much for your last reply which suggested to hold the Alt key.
    Regards

    Mirisa

+ 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. Script to copy excel table in to a powerpoint slide
    By Robert110 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2014, 06:15 PM
  2. Copy and paste some charts from excel into specific slide on a powerpoint template
    By ones4rus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 03:00 AM
  3. macro to copy paste excel name range to powerpoint new slide
    By koi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 04:55 PM
  4. Copy Graphs and other Data into PowerPoint a slide at a time.
    By kpierce in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2011, 02:11 AM
  5. Copy Range from Excel to Powerpoint Slide
    By cricrazy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2009, 07:11 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