Move or resize a chart (2024)

Click anywhere in the chart.

This displays the Chart Tools option on the ribbon

Under Chart Tools, on the Design tab, in the Location group, click Move Chart.

Do one of the following:

• To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.

• To move the chart as an object in another worksheet, click Object in, and then in the Object in box, select the worksheet in which you want to place the chart.

  

  Tip:You can also place a chart in another chart sheet.

  See Also

  Drag-able Excel Tables

To resize a chart, do one of the following:

• To change the size manually, click the chart, and then drag the sizing handles to the size that you want.

• To use specific height and width measurements, on the Format tab, in the Size group, enter the size in the Height and Width box.
  

• To change the size and scaling of the chart, on the Format tab, in the Size group, click the Dialog Box Launcher

  

  . Then in the Scale Height and Scale Width boxes, enter the numbers that you want.

  

Click anywhere in the chart.

This displays the Chart Tools option on the ribbon.

Click the Format tab, in the Size group, click the Dialog Box Launcher .