How To Create Chart Sheet In Excel

Oct 24, 2020 • edited Oct 25, 2020

How To Create Chart Sheet In Excel

So far we have only seen charts on the same worksheet as the source data (embedded charts). However, you can also move a chart to a separate sheet that only contains a chart (chart sheet).

To move a chart to a chart sheet, execute the following steps.

  1. Select the chart.
  2. On the Design tab, in the Location group, click Move Chart.

Move a Chart in Excel

The Move Chart dialog box appears.

  1. Click New sheet and enter a name.
  2. Click OK.

Click New sheet

Result:

Chart Sheet in Excel

Note: repeat these steps, but instead of New sheet at step 3, click Object in, to move the chart back to the same worksheet as the source data.

#Tutorial#How To#Data Analysis#Charts

How to Create Area Chart In Excel

How to create Color Scales In Excel