GCFLearnFree.org

This has really aided my job search and created ample opportunities.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Creating a Chart

Excel 2003

Single page view print copy

Creating a Chart

Creating a chart sheet

Sometimes you may want to create a chart and place it on a separate sheet in the workbook. This is called a chart sheet. Chart sheets can make your charts stand out, particularly when working with complicated spreadsheets.

To move an embedded chart to a chart sheet:

  • Create an embedded chart.
  • Select the chart to be moved to a chart sheet.
  • Choose Chart Location from the menu bar.

    Chart and Location Menu Selections

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

    (The As object in button adds the chart as an embedded object on the worksheet.)

    Chart Location Dialog Box

  • Click the OK button. The chart is displayed on a separate chart sheet in the workbook.

    Chart Sheet

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

previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.