refer_to_destination_sheet property

refer_to_destination_sheet property

When copying the range in the same file and the chart refers to the source sheet, False means the copied chart’s data source will not be changed. True means the copied chart’s data source refers to the destination sheet.

Remarks

The default value is false, it works as MS Excel. For example: if copying a chart with the data source “sheet1!A1:B10” from worksheet “sheet1 to other worksheet “sheet2”, The data source will be changed as “sheet2!A1:B10”

Definition:

@property
def refer_to_destination_sheet(self):
    ...
@refer_to_destination_sheet.setter
def refer_to_destination_sheet(self, value):
    ...

See Also

keep_macros property refer_to_sheet_with_same_name property