Change the location, display size, or position of a chart

To change the location of an existing chart in the workbook, you can place an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.) on a 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.), or you can turn a chart that is displayed on a chart sheet into an embedded chart in the worksheet. You can also place an embedded chart in a separate window.

On a chart sheet, you can change the display size of a chart by zooming in and out. When a chart is embedded in a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.), you can change its size, move it to the position that you want, or specify whether you want the chart to be moved or sized with cells on the worksheet.

What do you want to do?

Change the location of a chart

Change the display size of a chart sheet

Change the size or position of an embedded chart in the worksheet

Change the location of a chart

  1. Click the embedded chart or the chart sheet that you want to change.
  2. On the Chart menu, click Location.
  3. Do one of the following:
  • To place the chart on a chart sheet, click As new sheet, and then type a name for the new chart sheet in the As new sheet box.

 Note   A sheet tab is created for the chart at the bottom of the worksheet window.Sheet tabs

  • To place the chart as an embedded chart on a worksheet, click As object in, click a sheet name in the As object in box, and then click OK.

Drag the embedded chart where you want it on the worksheet.

 Note   If you move an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), you can locate it on the worksheet by clicking Go To on the Edit menu, and then clicking Special. Click Objects, and then click OK.

 Tip   You can also place an embedded chart in a separate window. Click the embedded chart, and then click Chart Window on the View menu.

Top of Page Top of Page

Change the display size of a chart sheet

  1. Click the tab of 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.).
  2. To zoom in or out of a chart sheet, click Zoom on the View menu, and then click the option that you want.

If you want to size the chart sheet so that it fills the entire workbook window, click Sized with Window on the View menu. When a chart sheet is sized with the window, you cannot use the zoom feature on the chart.

Top of Page Top of Page

Change the size or position of an embedded chart in the worksheet

You can move an embedded chart to any location on the worksheet, and change the size of the chart for a better fit.

By default, an embedded chart also moves and sizes with cells, but you can change that option so that the chart moves with cells without being resized, or doesn't move or size with cells but stays unchanged in the same location.

Move or resize an embedded chart

  1. Click the chart area of an embedded chart.
  2. To move the chart, drag it to another location.
  3. To resize the chart, point to a sizing handle. When the pointer changes to a double-headed arrow, drag the sizing handle until the chart is the size that you want.

Chart item being resized

Change how an embedded chart is positioned with cells

  1. Click the chart area of an embedded chart.
  2. On the Format menu, click Selected Chart Area.
  3. On the Properties tab, under Object positioning, click the option that you want.

Top of Page Top of Page

 
 
Applies to:
Excel 2003