Control Size of Charts Link in PPP to Excel 1

[HarryLO]

Hi: ) I am designing a PPP that uses charts that are created in Excel. The problem is there doesn't seem to be any correlation between the size of the chart in Excel and the size that shows up in PPP. How do I force PPP to update with the charts at the right size.
Thankx,

 

[SkipVought]

Hi,

There's no "right size" AFAIK. Your "right size" may even differ from slide to slide. In fact, you might have more than one chart on a slide.

You must have a whole passel of charts. You might want to try something like this...

    For Each sld In ActivePresentation.Slides
        For Each shp In sld.Shapes
            With shp
                If .AutoShapeType = msoShapeMixed Then
                    
                    .Top = 0
                    .Left = 0
                    .Width = ActivePresentation.PageSetup.SlideWidth
                    
                End If
            End With
        Next
    Next

Skip,

_[red][/red]

 

[HarryLO]

Skip-?)

Good point. I get it that you recommend a macro in PP to size each chart that is linked from Excel. That would do it by brute force, but isn't there a more sophisticated way from within the transfer protocol? Aren't these programs set up to talk to one another?

Thanks,
HARRYLO