Home » Microsoft Excel 2003 » 06 - Creating Charts
6

A Chart Sheet

You can size and scale the chart area, specify how it should be placed on the printed page; and then view it in the preview window.

1. Click Page Setup on the File menu.

2. Select the options you want on the Chart tab.

Note: To move and size the chart area of a chart sheet by using the mouse, you must click Custom on the Chart tab and then click OK to return to the chart sheet.

Tips: To print an embedded chart without its associated worksheet data, click the embedded chart to select it; and then follow the instructions for chart sheets. You can move and size the chart area of an embedded chart without using the custom option on the Chart tab (File menu, Page Setup command).

Add a Text Box to a Chart

  1. Click the chart to which you want to add a text box.
  2. On the Drawing toolbar, click Text Box.
  3. Click where you want one corner of the text box, and then drag until the box is the size you want.
  4. Type the text you want in the box. The text will wrap inside the box. To start a new line inside the box, press ENTER.
  5. When you finish typing, press ESC or click outside of the text box.