Move and Copy a Chart

To move or copy a chart object on the current worksheet

• Click once on the chart object to select it
• Click-and-drag the chart to a new location or Ctrl+click-and-drag to duplicate the chart in a new location

OR

• From the Edit menu, select Cut or Copy then click the cell where you want to position the top-left corner of the chart and from the Edit menu, select Paste

To move or copy a chart object to another workbook

If you copy a chart object to another workbook, a link is created between the two workbooks. The chart in the destination workbook is linked to the data in the source workbook.

• Open or create the source and destination workbooks
• Click once on the chart object to select it
• From the Edit menu, select Cut or Copy
• Switch to the destination workbook and click the cell where you want to position the top-left corner of the chart
• From the Edit menu, select Paste
• Save both workbooks

To move or copy a chart sheet

You can move or copy a chart sheet within the same workbook, to another open workbook or to a new workbook.

• Optionally, open the workbook you want to copy the sheet to then switch back to the source workbook
• Point to the sheet tab of the chart sheet to move or copy
• From the Edit menu, select Move or Copy Sheet... The Move or Copy dialogue box is displayed.
• Optionally, from the To book: list box, select the name of another open workbook or select (new book) to create a new workbook and move/copy the sheet to it
• From the Before sheet: box, select a location for the sheet
• To copy the sheet, click the Create a copy check box
• Click OK