Creating a Chart

Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.

Creating a chart sheet

Although Excel creates an embedded chart by default, in some situations you may want to place a chart on a separate sheet. A separate sheet with a chart on it is called a chart sheet. Chart sheets can make your charts stand out, particularly when you are working with complicated spreadsheets.

To move an embedded chart to a chart sheet:

  • Select the chart you want to move.
  • Choose ChartLocation.

    chart menu

  • In the Chart Location dialog box, select As a new sheet.
  • Click OK.

    chart location dialog box

Your chart should now display on a separate chart sheet in your workbook.

chart sheet

Important Point You can also use the Chart Location dialog box to rename the chart sheet.