How to draw filled rectangle on XY scatter plot?

[Kelvin Stott]

Hello,

I've been trying to add simple filled shapes (rectangle) onto my XY scatter plot in VBA. I tried using the following, but the coordinates don't match up with the xy coordinates on the plot, and seems to draw outside the plot:

    With MyChart.Shapes.AddShape(msoShapeRectangle, 10, 10, 20, 20)
        .Name = "IQR"
        .Fill.ForeColor.RGB = RGB(255, 153, 0)
    End With

Could somebody please let me know what I'm doing wrong?

 

[Kelvin Stott]

PS. I've also managed to draw the rectangle with 5 points (repeating the first) directly in the scatter plot, but unfortunately can't fill it as a shape.