Did you recently create a chart in Google Sheets and seek a simple way to move it to a new sheet in Google Sheets without sweating it? Well, you’re in luck today, as this guide has everything you’re looking for and more.
After reading this guide, you should be able to move chart to new sheet in Google Sheets with just a few clicks. Today’s guide will show you the different methods you can explore to move charts to new sheets in Google Sheets.
Let’s get started, shall we?
Using keyboard shortcut to move chart to a new sheet in Google Sheets
A keyboard shortcut is one of the easiest ways to move a chart to a new sheet in Google Sheets. This method is insanely popular and only involves pressing a few buttons on your keyboard.
For this method, you only need to use the keyboard shortcut Ctrl + C if you use a Windows computer or Command + C if you use a Mac.
After copying the chart, create and go to a new sheet and then press the shortcut, Ctrl + V, for Windows or Command + V if you use a Mac. This action will paste the chart to a new sheet.
We know this sounds like a lot to take in, so we have broken everything down into simple steps.
For this guide, we will use the following sample chart. Since you already have a chart you are working with, you can simply replicate the steps we will show you to get the same result.
Step 1: Select the chart
The first thing you want to do when moving a chart to new sheet in Google Sheets is to select the chart you want to copy. And guess what? This is super easy. Simply click anywhere on the chart, and the borders around the chart should turn blue. Here is what it should look like if you did things correctly.
Step 2: Copy the chart
After selecting your chart, you need to copy the chart. And since we are talking about the keyboard shortcut option, you only need to press Ctrl + C or Command + C if you use a MAC to copy the chart.
Step 3: Create a new sheet
Since we intend to move the chart to a new sheet, we must create a new one. To create a new sheet in Google Sheets, simply click the + icon located in the sheet name tab area. This action will create a new sheet where we will move our chart.
After completing this action, you should have a new blank spreadsheet like this.
Step 4: Paste the chart
After creating a new spreadsheet, you can go ahead to paste the chart into the new sheet by pressing Ctrl + V or Command + V on your keyboard, in case you use a Mac computer.
Here is what our new sheet now looks like:
An alternative way to move chart to new sheet in Google Sheets
If you find the keyboard shortcut method of moving chart to new sheet in Google Sheets confusing, you can try the alternative method we would show you in a bit. This method is called the copy chart method. Here is how to go about it.
Step 1: Select your chart
The copy chart option is among the easiest way to move charts to new sheets in Google Sheets. For this method, you need to first select the chart by clicking anywhere on the chart.
Step 2: Click the three dots at the top right corner of your chart
After selecting the chart, you’ll notice three dots at the top right corner of your chart.
Step 3: Copy chart
After clicking on the three dots located at the top right corner of your chart, you’ll see a list of options. From the options presented, select “Copy chart.” This action copies the chart into a clipboard, which you can then paste into a new sheet, as we described earlier.
Move charts to new sheets in Google Sheets using the move-to-own sheet option.
If you are looking for a straightforward process of moving a chart to a new sheet in Google Sheets, you’re welcome to explore this method. What we love most about this method is that it eliminates most of the steps highlighted in the previous method.
Here is how to execute this method:
Step 1: Select the chart
As we did for the earlier method, you’ll also need to select the chart for this method. And to do this, you only need to click anywhere within the chart. Here is what your chart should look like after being selected:
Step 2: Click the three dots on the top right of your chart
With the chart now selected, click on the three dots sitting on the top right corner of your chart and select the option “Move to own sheet”
After selecting the “Move to own sheet” option, Google Sheets automatically removes the chart from the current sheet and duplicates it in a new sheet created inside the current Google Sheets file you’re working with. Here, take a look at what your chart should look like after executing the “Move to own sheet” action.
By default, the new chart is named “Chart1” and is a little different from the regular spreadsheet you’re used to working with, as it has no grid.
If you look to the top right corner of the chart you recently moved, you’ll find different options including Copy chart, Edit chart, Publish chart, Download chart, and Delete chart. Feel free to explore these options as needed.
Move chart to a new sheet in Google Sheets through the Copy to option
If you have read to this point, we are sure you already love the two methods we have shown you thus far. Now, we want to show you another way to achieve the same result.
For this method, what we simply do is create a duplicate of the sheet housing the chart we would like to move. And just so you know, the process is pretty straightforward.
Step 1: Right-click on the sheet containing the chart
To execute the “Copy to” method of moving charts in Google Sheets, you need to right-click on the sheet containing the chart. And select the option for “Copy to.”
When you click the Copy to option, you’ll be presented with two options, either to copy to a new spreadsheet or copy to an existing spreadsheet. Choose the option that works best for you. For this guide, we will choose the copy to an existing spreadsheet option.
After executing the steps we highlighted above, you should have a new spreadsheet that looks exactly like this.
Note: This method moves all the content in your original spreadsheet to a new location called “Copy of Sheet1” Also, remember that this particular method is super important if you have many charts you plan to move at once. Not just that, this option is also great for when you want to share a chart with other users while restricting their editing privileges.
If you have struggled to move chart to new sheet in Google Sheets in the past, we are sure today’s guide has made the process straightforward.
In today’s guide, we highlighted three methods you could leverage to move charts in Google Sheets.
Feel free to use whichever method you find convenient.