Move chart to new sheet

A common task!

To move a chart to a new sheet in Excel, you can follow these steps:

Method 1: Using the "Move Chart" option

Select the chart you want to move.
Right-click on the chart and select "Move Chart" from the context menu.
In the "Move Chart" dialog box, select the sheet you want to move the chart to from the "Move chart to" dropdown list.
Click "OK" to move the chart.

Method 2: Using the "Copy" and "Paste" options

Select the chart you want to move.
Copy the chart by pressing Ctrl+C (or right-clicking and selecting "Copy").
Go to the new sheet where you want to move the chart.
Right-click and select "Paste" (or press Ctrl+V).
In the "Paste Options" dialog box, select "Move" to move the chart instead of copying it.

Method 3: Using VBA (for advanced users)

Open the Visual Basic Editor by pressing Alt+F11 or by navigating to Developer > Visual Basic in the ribbon.
In the Visual Basic Editor, double-click on the "ThisWorkbook" object in the Project Explorer.
In the code window, add the following code:
```
Sub MoveChart()
 Dim chart As Chart
 Set chart = ThisWorkbook.Sheets("OldSheet").Charts("ChartName")
 chart.Move After:=ThisWorkbook.Sheets("NewSheet").Range("A1")
End Sub
```
Replace "OldSheet" with the name of the sheet where the chart is currently located, "ChartName" with the name of the chart, and "NewSheet" with the name of the sheet where you want to move the chart.
Save the code by clicking "File" > "Save" (or press Ctrl+S).
Run the code by clicking "Run" > "Run Sub/User Form" (or press F5).

Note: Make sure to adjust the code to match your specific chart and sheet names.