Actually, I figured it out myself.
Here's my solution for anyone who is interested:
You need to "activate" the chart by doing the following:
ActivePresentation.Slides(i + 1).Shapes(yq + 2).Select
ActiveWindow.Selection.ShapeRange.OLEFormat.DoVerb Index:=1...
Hey,
I am pasting a lot of data from excel to powerpoint, here is a code fragment:
Sub adjustData()
'
' This sub changes the chart data to the relevant excel informaiton
'
Dim oGraph As Object
Dim oPPTShape As PowerPoint.Shape
Dim j As Integer
On Error GoTo xxx
Set...
OK! Your code works great in excel, and in powerpoint if you are not presenting. By while the presentation is not running I do not how to get this macro to run. I tried this:
-set the pasted chart's action setting to run the macro called "display" on a mouseover
-then made this macro:
Sub...
Hi,
Say I've declared a procedure in Excel, with a chart on a seperate sheet, that msgboxes what the value of the series is when you mouseover it, something like this:
>>
Private Sub Chart_MouseMove(ByVal Button As Long, _
ByVal Shift As Long, ByVal X As Long, ByVal Y As Long)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.