The sheet of targetRange and the sheet of the shape being added must be the same sheet.
IShape addChart( ChartType chartType, IRange range )
IShapes Interface IShapes Members Overload List