Changing Chart Size

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. (This is covered in a different ExcelTip.)

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.