How to Move and Resize a Chart in Excel

How to Move and Resize a Chart in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

How to Move and Resize a Chart in Excel

Usually, you will have to adjust a chart after it is inserted to ensure it doesn’t cover up data on the worksheet. You can resize a chart, move it within the worksheet, or move it to another worksheet.

Move a Chart

  1. Click the chart to select it.
  2. Click the chart’s border and drag it to the new location.
    Move and Resize
  3. Make sure the four-headed arrow is activated before clicking and dragging.

The chart is moved to where you dragged it.

Move Charts to a Chart Sheet

If you don’t want your chart on the same sheet as the data, you can move it to its own worksheet.

  1. Select the chart you want to move.
  2. Click the Move Chart button on the Design tab.
  3. Select New sheet.
  4. Type a name for the sheet.
  5. Click OK.
    Move and Resize

The chart is moved to its own worksheet.

Resize a Chart

Eight sizing handles appear along the chart edges once it is selected. Sizing handles are used to change the size of charts and other objects.

  1. Click the chart to select it.
  2. Click and drag the chart’s sizing handle.
    Move and Resize

    Make sure the two-headed arrow is activated before clicking and dragging.