How to Move a Chart to a New Sheet in Excel

How to Move a Chart to a New Sheet in Excel. Creating a standalone chart that fits perfectly on a separate sheet can enhance data presentation in Excel. Here’s how to move a chart from one sheet to a new chart sheet:

How to Move a Chart to a New Sheet in Excel

  1. Select the chart and navigate to the Design tab.
  2. Locate the ‘Move Chart’ icon in the ribbon (Excel 2016) and click on it.
  3. In the dialog box, choose the ‘New sheet’ radio button and rename the chart if desired.
  4. Click ‘OK’ to confirm.

Voila! The chart is now on a new chart sheet.

On a chart sheet, the chart fits well and remains fixed, allowing all chart-related tasks while presenting data neatly. You can move other charts to the same sheet, but they’ll float around while the first chart becomes the sheet’s background.

Alternatively, right-click on the chart for the ‘Move Chart’ option. You can move the chart to a different normal sheet by selecting ‘Object in:’ and choosing the desired sheet from the dropdown.

To move a chart from a chart sheet back to a normal sheet, right-click on the chart on the chart sheet, select ‘Move Chart,’ then choose the desired sheet from ‘Object in:’.

That’s how you move charts to new chart sheets in Excel! If you have any questions or doubts, feel free to ask in the comments section below.
Compare items
  • Total (0)
Shopping cart