creating an "ovlPointer" with .add method?

[bigt95nt]

Below is a snipet of code that modifies the shape "ovlPointer" Properties Try as I may, I have not able to create this object with .add method.

Please Comment

 With mchtChart
            dXVal = (X * dPixelSize / dZoom - .ChartArea.Left)
            dYVal = (Y * dPixelSize / dZoom - .ChartArea.Top)
            With .Shapes("ovlPointer")
              .Height = .Width                    
              .Left = dXVal - (.Width / 2) - 4
              .Top = dYVal - (.Height / 2) - 4
 
            End With
        End With

 

[shg]

What code have you tried?

 

[bigt95nt]

get error "subscript out of range"

ActiveChart.Shapes.AddShape(ovlpointer, 196, 64, 72, 72).Select

 

[shg]

I think the Add method, as applied to Shapes, applies to worksheets, not charts.

 

[Andy Pope]

What is the value of ovlpointer

perhaps you meant something like msoShapeOval