What Is a Chart Sheet?

A chart sheet is a Microsoft Excel worksheet that is dedicated to one chart. When a user creates a chart in Excel, the default settings of the software program will embed it into a sheet with other data; however, the user may wish to move the chart to a separate sheet.

Microsoft Excel is a spreadsheet software program commonly used in business. It allows the user to organize data into worksheets. Tabs at the bottom of the page contain the names of all of the sheets and allow the user to switch between worksheets easily. Excel allows for a great deal of customization when it comes to organizing data, and the design, display and location of charts is no exception.

If a user wants to have a chart on a separate worksheet, he or she can create a chart sheet. To move a chart to its own sheet after creating it in Excel, the user should, after selecting the chart:

  1. Look for the Design tab within the Chart Tools tab at the top of the page.
  2. Click on “Move Chart.” A dialog box will appear.
  3. Select “New Sheet” in the dialog box and input a name for the chart sheet. This will create a new chart sheet.