Copy Shapes between Worksheets

Copying a Picture from one Worksheet to Another

To copy a picture from one worksheet to another, use the Worksheet.pictures.add method as shown in the sample code below.

Copy a Chart from one Worksheet to Another

The following code demonstrates the use of Worksheet.shapes.add_copy method to copy a chart from one worksheet to another.

Copy Controls and Other Drawing Objects from One Worksheet to Another

To copy controls and other drawing objects, use the Worksheet.shapes.add_copy method as shown in the example below.