Moving and Resizing an Embedded Excel 2007 Chart

11 of 12 in Series: The Essentials of Working with Charts in Excel 2007

After you create a new chart in an Excel 2007 worksheet, you can easily move or resize the embedded chart. Whenever an embedded chart is selected (as it is automatically immediately after creating it or after clicking any part of it), the Chart Tools contextual tab with its Design, Layout, and Format tabs appears on the Ribbon, and Excel outlines each group of cells represented in the selected chart in a different color in the worksheet.

You can always tell when a graphic object, such as a chart, is selected because you see selection handles — those tiny dots around the edges of the object.

When an embedded chart is selected in a worksheet, you can move or resize it as follows:

  • To move the chart, position the mouse pointer somewhere inside the chart and drag the chart to a new location.

  • To resize the chart, position the mouse pointer on one of the selection handles. When the pointer changes from the arrowhead to a double-headed arrow, click and drag the side or corner (depending on which handle you select) to enlarge or reduce the chart.

    Drag a side or corner handle of a selected chart to resize it.
    Drag a side or corner handle of a selected chart to resize it.

When the chart is properly sized and positioned in the worksheet, set the chart in place by deselecting it (simply click the mouse pointer in any cell outside the chart). As soon as you deselect the chart, the selection handles disappear, as does the Chart Tools contextual tab on the Ribbon.

To re-select the chart later on to edit, size, or move it again, just click anywhere on the chart. The moment you do, the sizing handles return to the embedded chart and the Chart Tools contextual tab reappears on the Ribbon.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
The Essentials of Working with Charts in Excel 2007

Advertisement

Inside Dummies.com