How to copy and paste multiple charts to PowerPoint

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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———————–

Reply | Quote

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.

Reply | Quote

There is a software called CNET installer,you can adownload it and can copy and paste multiple charts to powerpoint.
Hope it helps!!!

Reply | Quote

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

Reply | Quote