OLEObject.BottomRightCell (Excel)

Returns a Range object that represents the cell that lies under the lower-right corner of the object.

Dim rngBottomRightCell As Range
Set rngBottomRightCell = ActiveChart.OLEObjects(1).BottomRightCell