Have you ever created a chart on one sheet and wished you could transfer or duplicate it to another tab? Well, you’re in luck! In this article, I will not only show you multiple ways to move or copy charts to another sheet in Google Sheets but also demonstrate how to change the data that your duplicated charts are connected to.
Moving or Copying a Chart to Another Sheet
To move or copy a chart to another sheet in Google Sheets, follow these simple steps:
- Click once on the chart you want to move or copy to another sheet.
- Press Ctrl + C on your keyboard to copy the chart.
- Click on the tab where you want to move or copy the chart.
- Press Ctrl + V on your keyboard to duplicate or paste the chart.
- Optional: Delete the old chart.
Using the “Move to Own Sheet” Option
Google Sheets offers an option called “Move to Own Sheet,” which creates a new tab and moves the chart to that tab. While this method is convenient for some, many prefer to have more control over where their charts are copied to. However, let’s go over this method anyway.
To move a chart to its own sheet in Google Sheets, follow these steps:
- Click on the chart you want to move to its own sheet.
- Click the three dots in the upper right corner of the chart to open the chart menu.
- Click “Move to Own Sheet.”
After following these steps, Google Sheets will create a brand new sheet and move your chart to it. The tab will be named “Chart1,” and it will only display the chart without any background cells.
Copying and Pasting Charts
Another straightforward method to move your charts to another sheet is by copying and pasting. Here’s how you can do it:
- Select the chart you want to move by clicking on it once.
- Press Ctrl + C on your keyboard, or click the three dots in the upper right corner of the chart and then click “Copy chart.”
- Click on the tab where you want to paste the chart and select the target cell.
- Press Ctrl + V on your keyboard to paste the chart into the selected location.
- The original chart will still remain in its original location, allowing you to delete it if needed.
If you double-click on the new or moved chart, you can see that it refers to the same data as before. The tab name will now be included in the data range if the data is held on a different tab than the chart itself.
Alternatively, you can use the chart menu option to copy the chart instead of using the keyboard shortcut. Simply select the chart, click the three dots in the upper right corner of the chart, and choose “Copy chart.” The rest of the process remains the same.
Duplicating Entire Tabs to Duplicate Charts
If you need to move multiple charts to new tabs simultaneously, you can duplicate the tab where your charts are located. This method is especially useful when you want to create an additional set of charts reflecting slightly modified data sets.
To duplicate a spreadsheet tab in Google Sheets, follow these steps:
- Right-click on the tab you want to duplicate.
- Click “Duplicate.”
Google Sheets will create a copy of the original tab, allowing you to make any necessary edits, such as changing the data range in the charts to connect them with different data sets.
Moving or Duplicating Charts to Another Google Sheets File
Not only can you move or copy charts within the same Google Sheets file, but you can also duplicate them to another Google Sheets file. This is a great method for transferring charts you have already created to a different file.
To copy a tab to a new or existing Google Sheets file, follow these steps:
- Right-click on the tab you want to copy into another file.
- Hover your cursor over “Copy to.”
- Select either “New spreadsheet” or “Existing spreadsheet.”
- If you choose “Existing spreadsheet,” select the appropriate Google Sheets file.
Now that you know all the methods to move or copy your charts into new sheets in Google Sheets, you can easily organize and present your data the way you want it.
This content was originally created by Corey Bustos / SpreadsheetClass.com.