How to move and resize a chart in Excel

Let’s take a look.

By default, Excel charts will automatically move and resize when cells underneath them change.

The same is true of rows.

If we increase or decrease row heights, the chart automatically expands and contracts.

you’ve got the option to control this behavior by adjusting the chart’s position property.

tap the Format Selection button on the Chart Tools Layout tab.

This will initiate the Format Chart Area dialog box.

In the dialog, click Properties.

At the top are options for Object positioning.

Note that by default, the chart will both move and resize with cells.

Let’s try the second option, “Move but don’t size with cells.”

Now, if we delete a column, the chart shifts on the worksheet.

Finally, let’s turn off move and resize options altogether.

This time, let’s set object positioning to “Don’t move or size with cells.”

Now, changes to rows or columns do not affect the chart.

To move a chart manually, hover your mouse over the chart area until you see a 4-headed arrow.

Then, just click and drag to a new location.

To resize a chart, just use any one of the eight handles visible when the chart is selected.

For example, we can enter a height of 4" and a width of 6".