Convert Excel charts to Power Point

[RompStar]

I have a whole bunch of Excel Charts, my boss wants me to convert them to Powerpoint, because it looks better in that for presentation purposes and I know nothing about power point, I can figure things out by clicking on it, but that's about it...

Is there a tool that will convert a Excel chart to Powerpoint automatically ?

Or is that wishful thinking.

 

[Bubbis Thedog]

Type in "chart" into Help in PowerPoint, and that should lead you toward your goal. Office products were designed to work together, so it shouldn't be too big of a chore, romp.

Good luck!

 

[RompStar]

yes, you are right, time to get my hands dirty :- )

:wink:

 

[Datsmart]

RompStar

I would suggest copying the chart as a picture and then pasting to PowerPoint. That way the chart retains its proper dimensions.
Hold down the Shift Key and click the Edit Menu to get the Copy as Picture option in Excel.

HTH
Datsmart

 

[RompStar]

see :- )

The file that I am working on is in PowerPoint, and it has charts in the overall presentation in the pages of the power point documnet.

When you click on the chart it's linked to an Excel document, so my boss wants me to make it a power point charts and be linked to that data still in excel, but be powerpoint chart and not linked to the excel chart, like it is now..

So I would create a new chart, but how the heck to I add the links to the external data file ?

man, this sucks!!!

 

[Bubbis Thedog]

What's the difference between linking the embedded chart to an Excel chart and having the source data reflect data in a source Excel file? Seems to me like that would just be doing more work than is necessary.

 

[RompStar]

beats the crap out of me, this just landed on my lap and I never worked before with this, so hooray!

 

[Bubbis Thedog]

hahahaha

Okay, so then you got the chart into PowerPoint, right? What's the issue now?

 

[RompStar]

well, I stabbed at it for a few hours, punching the keyboard ever so slightly less with time, finally getting the hang of it, hey, I'll the only guy in the office to know how, maybe that's a good thing or a curse.

So Friday is here, I am off.

:wink:

 

[Justinlabenne]

Probably a bit late but this code will copy whatever Excel chart you select into a new powerpoint slide as a piture (not linked)

If it's of use, post back if you need modifications

Option Explicit

Sub CreatePowerPointFromChart()
'   Used late-binding to avoid setting a reference to the
'   Microsoft PowerPoint #  object library
    Const ppLayoutBlank As Integer = 12
    Const ppWindowMaximized As Integer = 3
    Dim PPTApp As Object
    Dim Pres1 As Object
    Dim Slide1 As Object
    
    If ActiveChart Is Nothing Then
        MsgBox "You must select a single chart for exporting ", 0
        Exit Sub
    End If
    
    Set PPTApp = CreateObject("PowerPoint.Application")
    
    With PPTApp
        .Visible = True
        .WindowState = ppWindowMaximized
        Set Pres1 = PPTApp.Presentations.Add
    End With
     
    Set Slide1 = Pres1.Slides.Add(1, ppLayoutBlank)
    
'   Copy the chart over
    ActiveChart.CopyPicture
    PPTApp.ActiveWindow.View.Paste
   
'   Save the new ppt in the same path as the Excel file
  '  Pres1.SaveAs ThisWorkbook.Path & "\new.ppt"
  '  Pres1.Close
  '  PPTApp.Quit
End Sub