Move Chart to New Sheet – Excel & Google Sheets

This tutorial will demonstrate how to move a graph to another worksheet in Excel.

Move Graph to Another Worksheet in Excel

Start with your Graph

In this example, the graph we have is currently on 2020 Worksheet and we want to move it to the 2019 Worksheet.

Moving your Graph

1. Right click on the Graph
2. Select Move Chart

 

3. Select the dropdown next to Object

4. Click the tab you would like to move the chart to

 

Final Chart on New Worksheet

As you can see, the graph is now on the 2019 tab as requested

 

Move Graph to Another Worksheet in Google Sheets

Starting with your Graph

In a similar scenario as above, we want to move the graph to the 2019 workbook instead of 2020.

Copy Chart

1. Click on the three dots at the top right of the chart
2. Select Copy Chart

 

Paste Chart

1. Right Click on Graph
2. Select Paste

 

Final Graph on New Worksheet

As you can see, the new graph is now on the 2019 tab.