Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Saudi Arabia
    Posts
    322
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to copy and paste multiple charts to PowerPoint

    hi all

    I have several worksheets that contain multiple charts. I want to copy the
    charts from Excel to PowerPoint with one chart to a slide.,My question is
    there a way to quickly export the charts to PowerPoint so that each slide
    contains a different chart.

    TIA
    TIA
    dubdub

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Lounger
    Join Date
    Dec 2009
    Location
    Melbourne Victoria Australia
    Posts
    36
    Thanks
    4
    Thanked 2 Times in 2 Posts
    It is possible to select all Excel charts in one hit by using the Control key and copying them. You can then paste them into Powerpoint. The only problem then is they will all copy to the one slide. You then need to select each individual chart in that slide to move it into the required slide. If you have a lot of charts it will be easier to do only a few at a time. Still a bit cumbersome though.

  4. #3
    3 Star Lounger
    Join Date
    Feb 2007
    Location
    Durham, Durham, United Kingdom
    Posts
    279
    Thanks
    0
    Thanked 6 Times in 6 Posts
    Do you know how to use vba code?

    In your Excel file press ALT f11
    In the code window that opens INSERT > Module
    Copy and paste in the code below and hit f5.

    Note the code is for charts as worksheet objects.

    WORK ON A COPY if youre not sure.

    '------copy from here-------------------
    Sub Charts_PPT()
    Dim ocht As ChartObject
    Dim ws As Worksheet
    Dim pptApp As Object
    Dim pptPres As Object
    Dim pptSld As Object
    Set pptApp = CreateObject("PowerPoint.Application")
    pptApp.Visible = True
    Set pptPres = pptApp.Presentations.Add(msoTrue)
    For Each ws In ActiveWorkbook.Worksheets
    For Each ocht In ws.ChartObjects
    ocht.Copy
    Set pptSld = pptPres.Slides.Add(pptPres.Slides.Count + 1,11)
    pptPres.Windows(1).View.GotoSlide (pptSld.SlideIndex)
    pptSld.Shapes.Title.TextFrame.TextRange = ws.Name & " " & ocht.Name
    With pptSld.Shapes.Paste
    .Align 1, True
    .Align 4, True
    End With
    Next ocht
    Next ws
    End Sub
    ' --------to here-----------------------
    Last edited by JohnWilson; 2012-07-07 at 12:59.

  5. #4
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Saudi Arabia
    Posts
    322
    Thanks
    1
    Thanked 0 Times in 0 Posts
    sorry for the late reply, although i need the copy as a chart, i gave the code a try and i got a run time error '1004' with the message apple cation-defined or object-defined error.
    TIA
    dubdub

  6. #5
    New Lounger
    Join Date
    Nov 2012
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There is a software called CNET installer,you can adownload it and can copy and paste multiple charts to powerpoint.
    Hope it helps!!!

  7. #6
    Lounger
    Join Date
    Dec 2009
    Location
    Melbourne Victoria Australia
    Posts
    36
    Thanks
    4
    Thanked 2 Times in 2 Posts
    Sorry new lounger but I think you have the wrong title.
    CNET Installer powers secure downloads from CNET Download.com
    (their words). Using this installer to download software can also bring unwanted toolbars etc into your computer unless you are very alert.
    Mal

Posting Permissions

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