Move or resize a chart

You can move a chart to any location on a worksheet or to a new or existing worksheet. 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 worksheet, 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 worksheet cells.

What do you want to do?


Move a chart to another location in a worksheet

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

Top of Page Top of Page

Move a chart to another worksheet

  1. Click anywhere in the chart.

This displays the chart tools, adding the Design, Layout, and Format tabs.

  1. On the Design tab, in the Location group, click Move Chart.

Excel Ribbon Image

  1. 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 (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.).

Top of Page Top of Page

Resize a chart

  1. 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 Shape Height and Shape Width box.
    Excel Ribbon Image
  • To change the size and scaling of the chart, on the Format tab, in the Size group, click the Dialog Box Launcher Button image next to Size, and then do the following:
  1. Click the Size tab.
  2. Under Size and rotate, in the Height and Width boxes, select the numbers that you want to use.
  3. Under Scale, in the Height and Width boxes, select the numbers that you want.

Top of Page Top of Page

Prevent a chart from moving and sizing with cells on the worksheet

  1. Click anywhere in the chart.

This displays the chart tools, adding the Design, Layout, and Format tabs.

  1. On the Format tab, in the Size group, click the Dialog Box Launcher Button image next to Size.

Outlook Ribbon Image

  1. On the Properties tab, under Object Positioning select the option that you want.

Top of Page Top of Page

 
 
Applies to:
Excel 2007