Google Sheets: How to Move a Chart to Its Own Sheet

Charts & pivot tables · Updated November 21, 2026

To move a chart in Google Sheets to a new sheet, select the chart, click its three-dot More menu, and choose Move to own sheet. Sheets creates a separate tab for the chart; the chart’s source data stays where it is.

What “Move to own sheet” does

A chart normally sits on top of a worksheet as a movable object. Choosing Move to own sheet takes it off that worksheet and places it on a dedicated chart tab in the same spreadsheet. The new tab contains the chart, not a copied set of the cells that produced it.

The chart remains connected to its source data. Moving it changes its location in the spreadsheet, not the range it uses or the values in that range. If the source cells change, the chart can reflect those changes as it did before. You can still open the chart editor to adjust the data range, chart type, labels, and appearance.

This is useful when a chart needs more room, when you want a reader to focus on a visualization without seeing surrounding cells, or when a workbook has several charts that deserve their own tabs. It does not create a new spreadsheet file or turn the chart into a static picture.

Steps to move a chart to a new sheet

  1. Open the spreadsheet in Google Sheets in a desktop web browser and go to the sheet containing the chart.
  2. Click the chart once so its border and selection handles appear. If you double-click, the chart editor may open; close it or click the chart itself to select the chart object.
  3. Click the chart’s three-dot More menu, usually at its upper-right corner.
  4. Select Move to own sheet.
  5. Wait for Sheets to create the chart tab, then click that tab to view the result.

The new tab is part of the same spreadsheet and appears alongside the existing sheet tabs. If you do not see the menu, first make sure the chart itself—not a cell behind it—is selected. On a narrow browser window, the chart controls may be less obvious, so enlarging the window can help.

What happens to the data and the original sheet

The cells used by a chart are not moved, deleted, or hidden by this command. For example, if a monthly sales chart uses dates in A1:A13 and sales values in B1:B13, those cells remain in their original sheet after the chart gets its own tab. The chart continues to use its configured data range.

This separation can make a workbook easier to navigate, but it also means the chart tab depends on data elsewhere in the file. If someone later deletes the source rows, changes the range, or removes the source sheet, the visualization may no longer show the intended information. Moving a chart is not a way to archive its data independently.

For a report, consider naming the data sheet clearly and keeping source labels descriptive. A chart tab titled “Quarterly revenue” is more useful when its underlying table is clearly identified and maintained. If you share the spreadsheet with other people, they can still navigate between the chart and the data, subject to their access to the file.

How to edit the chart after moving it

Moving the chart does not remove its editing controls. On the chart tab, double-click the chart to open the chart editor. The editor has Setup and Customize tabs. Use Setup to change the chart type, data range, or how the data is organized; use Customize for options such as chart and axis titles, legend placement, colors, and gridlines. Available settings vary by chart type.

For instance, if you move a column chart of monthly sales and later add another month to the source table, check the chart’s data range if the new month does not appear. The move itself does not automatically guarantee that a range includes future rows; that depends on the range and how the chart was set up. You can adjust the range in Setup rather than rebuilding the chart from scratch.

To reposition or resize a chart within a regular worksheet, select it and drag it or use its handles. That is different from Move to own sheet: dragging changes the chart’s position on the current sheet, while the menu command gives it a dedicated tab.

Moving a chart back or placing a copy elsewhere

If you decide that the chart should be embedded in a worksheet again, copy the chart from its chart tab, switch to the destination sheet, and paste it. Select the chart object before copying, rather than selecting cells, so that the chart itself is copied. After pasting, check that the chart is in the expected location and still displays the intended data before removing the chart-only tab.

Copying is also useful when you want a chart on a summary sheet while retaining the original chart tab. A copied chart is a separate chart object, so changes to its size or formatting need not be made to both charts in exactly the same way. Check the data range on the copy if you intend it to show different information. Avoid deleting the original until you have verified the copy and confirmed that the spreadsheet no longer needs the original tab.

Google Sheets’ Move to own sheet command is not the same as making a duplicate. If you need both an embedded version and a chart-only version, make a copy first or copy and paste the chart, then keep the versions you actually need.

When a separate chart sheet is useful

A dedicated chart tab is a good choice when the chart is the main point of a report, when a large visualization feels cramped beside a data table, or when people need to review a chart without scrolling around a busy worksheet. It can also make a presentation-style spreadsheet feel more organized, especially if the tabs have descriptive names.

An embedded chart may be better when readers need to compare it directly with the rows that support it. For example, a small sparkline-like comparison is not the same as a full chart, but a regular chart placed next to a table can make a particular month or category easier to interpret. Keeping the chart and source table together can also help a collaborator understand what the visualization represents.

  • Choose its own tab for a large, standalone visualization or a chart-focused report.
  • Keep it embedded when its nearby cells provide important context or when readers need to inspect the chart and table together.
  • Keep both versions only when each has a clear purpose, such as a detailed chart tab and a smaller overview chart.

Common problems and practical checks

The menu option is missing: confirm that the chart object is selected. A selected cell shows a cell outline, while a selected chart has a border and handles. Click once on the chart and look for its More menu. If you are editing the chart rather than selecting it, exit the editor and select the object.

The new tab appears empty or the chart is hard to see: click the new tab and allow the sheet to finish loading. Check browser zoom and window size, then select the chart if you need to inspect its controls. If it is genuinely blank or displays an error, open the chart editor and verify its data range and source cells.

The chart no longer includes recent data: inspect the range in the chart editor’s Setup tab. The chart may be using a fixed range that does not include newly added rows. Moving the chart does not expand that range by itself.

You cannot find the command on a phone or tablet: the instructions here describe the Google Sheets browser interface on a computer. The mobile app’s controls and available editing options can differ. If the chart menu is difficult to access in the app, open the spreadsheet in a desktop browser to use the steps above.

Before sharing a chart-only view, check the chart title, axis labels, legend, and source data for clarity. A dedicated tab provides more space, but it does not automatically make a chart easier to interpret or ensure that its labels explain the units and time period.

Google Sheets and Excel handle this differently

Google Sheets uses the chart’s More menu and the command Move to own sheet. In Excel for Microsoft 365 on Windows, the comparable chart-sheet operation is available from the selected chart’s Chart Design > Move Chart command, which opens a dialog for placing the chart in a new chart sheet or as an object on a worksheet. The applications use different interfaces, so Excel instructions should not be followed as if they were Google Sheets menu steps.

In either program, placing a chart on its own sheet is distinct from moving or copying the source data. If you are switching between the two applications, confirm that the chart’s data range, labels, and formatting are correct after importing or copying a workbook; similar chart concepts do not guarantee identical layouts or controls.

Frequently Asked Questions

Does moving a chart create a new spreadsheet?
No. It creates a chart tab inside the spreadsheet you already have. The original sheets and source cells remain in that file.

Will the chart update when I change the data?
It can continue to reflect changes in its source range. If added rows do not appear, open the chart editor and check the range in Setup; the chart may not include those rows yet.

Can I move a chart to a particular existing sheet with this command?
Move to own sheet creates a dedicated chart tab; it does not ask you to choose an existing worksheet. To place a chart on an existing sheet, copy the chart, switch to that sheet, and paste it.

Can I move the chart back to the sheet it came from?
Copy the chart from its chart tab and paste it onto the original or another worksheet. Check the pasted chart before deleting the chart-only tab, particularly if you want to preserve both versions.

Does moving a chart change its size or design?
The command changes where the chart lives, not its source data or intended design. You can still use the chart editor to adjust its setup and customization after the move.

Can I put more than one chart on the new chart tab?
The command moves the selected chart to its own tab. If you want multiple charts together, keep them embedded on a regular worksheet or copy additional charts onto a worksheet where you can arrange them.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.