ChartObject.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 = ActiveSheet.ChartObjects(1).BottomRightCell