Chart sheet in Excel

So far, we have seen charts that were placed on the sheet along with the original data (embedded charts). However, you can move a chart to a separate sheet that contains only that chart (chart sheet).

To move a chart to a separate sheet, do the following:

1. Select a chart. Tab group activated Working with charts (The Chart Tools).
2. On the Advanced tab Constructor (Design) click Move Chart (Move Chart). A dialog box will appear. Moving a chart (Move Chart).
3. Put a marker in front of the parameter On a separate sheet (New sheet) and enter a title.
4. Press OK.

Result:

Note: Repeat the above steps, but instead of On a separate sheet (New sheet) select item on existing sheet (Object in) to return the chart back to the sheet with the original data.