Move or resize a chart

You can move a chart to any location on a sheet or to a new or existing sheet. You can also change the size of the chart for a better fit.

By default, a chart is moved and sized with cells. When you change the size of cells on the sheet, the size of the chart adjusts accordingly. You can change this positioning option if you don't want to move or resize the chart together with the sheet cells.

Do any of the following:

Move a chart to another location in a sheet

  • To move a chart, drag it to the location that you want.

Move a chart to another sheet

You can move a chart to another sheet or put a chart in a new chart sheet.

  1. Click anywhere in the chart.

  2. On the Chart menu, click Move Chart.

    Move Chart dialog box

  3. Do one of the following:

To

Do this

Display the chart in a new chart sheet

Select the New sheet option, and then in the New sheet box, type a name for the new chart sheet.

Display the chart as an embedded chart in a sheet

Select the Object in option, and then in the Object in box, select the sheet that you want to place the chart on.

Resize a chart

  • To resize a chart, do one of the following:

To

Do this

To resize the chart manually

Click the chart, and then drag the sizing handles to the size that you want.

To use specific height and width measurements

Click the chart, and then on the Format tab, under Size, enter the size in the Height and Width boxes.

Tip: To maintain the proportions as you resize a chart, select the Lock Aspect Ratio check box between Height and Width.

Control how a chart moves and sizes with cells on the sheet

  1. Click anywhere in the chart.

  2. On the Format menu, click Format Chart Area.

  3. Click Properties, and then under Object Positioning, do one of the following:

To

Do this

Make the chart stay with the cells when the cells move (for example, when the range or table that contains the cells is sorted) and to resize the chart when cell height and width changes

Select Move and size with cells.

Make the chart stay with the cells when the cells move (for example, when the range or table that contains the cells is sorted), but keep the chart's size independent of the changes to cell height and width

Select Move but don't size with cells

Keep the chart's position and size independent of the changes to cell position, height, and width

Select Don't move or size with cells.

See also

Change a chart

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×