Section 8 - Moving and Resizing a Chart

If the chart is embedded in the worksheet, you can adjust where it will appear in print by sizing and moving the chart with the mouse in the worksheet. Note: moving and resizing a chart is similar in Excel XP, 2007 and MAC Excel 2004.

• To move the chart, click on the blank space of the chart then click and drag.

• To resize the chart, select the chart and move your cursor to one of the black boxes on any side of the chart. When the cursor changes to a double sided arrow you can now pull the chart in any direction.

If the chart is on a separate sheet, you can adjust the chart area, place it on the page, and view it in the preview window.

Excel XP or MAC Excel 2004

• To move and size the chart area of the chart sheet, select Page Setup in the File menu.
• Click on the Chart tab. Select what options you wish to change.
• Click OK.

Excel 2007

• To move the location of the chart in Excel 2007, select the Design tab under the Chart tools and click on the Move Chart Location button, as shown below: