Changing Chart Size

Summary: Got a chart that isn't quite the right size? Adjusting the size is just as easy as resizing any other graphic, as explained in this tip. (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. (This is covered in a different ExcelTip.)

You change the size of an embedded chart as you would any other graphical object in Excel:

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.
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.
Release the mouse button. The chart is resized and reformatted.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2209) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.

Check out ExcelTips: Serioius Sorting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Changing Chart Size