Itys

(This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If you are working with an embedded chart, you can change the size of the chart to any size you want. You cannot directly change the size of a chart sheet; it is set to be a single page. You can modify the printed size of a chart sheet, however.
You change the size of an embedded chart as you would any other graphical object in Excel:

1. Click once on the chart. Handles appear around the chart border. As you move the mouse pointer over these handles, they change to sizing arrows.
2. Click and hold the left mouse button and drag a sizing handle until the graphic is the size you want. The arrow heads on the mouse pointer indicate the direction which you can move the border.
3. Release the mouse button. The chart is resized and reformatted.