Excel 2003


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.
- 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.)
- Click the OK button. The chart is displayed on a separate chart sheet in the workbook.
You can also use the Chart Location dialog box to rename the chart sheet.