Excel 2003

Moving, Resizing, and Deleting Charts

Introduction

By the end of this lesson, you should be able to:

  • Move a chart
  • Resize a chart
  • Delete a chart

Moving a chart

An embedded chart can be moved anywhere on a worksheet. The easiest way to move a chart is to drag it around the worksheet.

To move a chart:

  • Click anywhere on the white space in the chart, and use the cursor to drag the chart anywhere on the worksheet.

    Move a Chart
  • Release the mouse button to place the graph in its new location.

Resizing a chart

Charts can be resized—made larger or smaller—to fit on a worksheet. Chart titles are sized in proportion to how large or small you make the chart. And within the chart area, the legend and/or plot area can be made larger or smaller. Chart titles can be moved but not resized.

To resize a chart:

  • Click anywhere on the white space of the chart area, plot area, or legend where you want to move or resize.

    Chart Components
  • Point the mouse to one of the grab handles or resize cursor—the pointer changes to a double-headed arrow—to resize the chart.

    Chart Grabhandles
  • Use the mouse to drag the sizing handle until the chart is resized to the desired size.

Deleting a chart

Any embedded chart or chart sheet can be deleted from a worksheet. A chart sheet is deleted in the same manner a worksheet is deleted. This section discusses how to delete an embedded chart.

To delete a chart:

  • Click anywhere on the white space of the chart area to select the chart.
  • Press the Delete key on your keyboard.

If you have difficulty deleting a chart, click anywhere outside of the chart and then select the chart again.

Challenge!

  • Open your Monthly Budget file.
  • Move the chart so it's located below row 19 and all of the data.
  • Resize the chart so it's larger than its current size.
  • Save and close the document.