Moving a Chart

When you first create a chart, Excel places the chart in the middle of the worksheet. But often times this means your chart is covering data that you want to be able to view. You can move a chart by selecting it and then dragging it anywhere on the worksheet.

To move a chart by dragging:

  1. Select the chart you want to move.
  2. Click in the Chart Area.
  3. With your left mouse depressed, drag the chart to the new location on the worksheet.
  4. Release the mouse button.


When moving a chart, be sure you have selected the entire chart area; otherwise you will be moving the data within the chart.

To delete a chart, select the chart and press the Delete key or point to Clear on the Edit menu and select All.

To move a chart to a new worksheet:

  1. Right-click on the chart you want to change and select Location... from the menu
    OR
    Select Location... from the Chart menu.
  2. Select the worksheet to which you want to move your chart or click the radio button for As new sheet:
  3. Click OK.