Microsoft Office Tutorials and References
In Depth Information
Moving and Resizing a Chart
Basic Tasks with
4. When you’re finished, click a cell anywhere in theworksheet to go back to
At this point, life returns to normal, and the Chart Tools tabs disappear.
The four-way arrow is a signal that you can click
here to move the chart. If you move to one of
the corners, you’ll see an angled two-way arrow,
which lets you resize the chart.
Tip: To remove a chart in one fell swoop, just select it with the mouse, and then press Delete.
Under the hood
How Excel Anchors Charts
Although charts appear to float above the worksheet,
they’re actually anchored to the cells underneath. Each
corner of the chart is anchored to one cell (these anchor
points change, of course, if you move the chart around).
This fact becomes important if you decide to insert or
delete rows or columns anywhere in your worksheet.
11, the chart stretches, becoming one row taller. Similarly,
if you delete column D, the chart compresses, becoming
one column thinner.
If it bugs you, you can change this sizing behavior. First,
select the chart, and then head to the ribbon’s Chart Tools
| Format➝Size section. Click the dialog launcher (the
square-with-an-arrow icon in the bottom-right corner).
When the Size and Properties dialog box appears, choose
Properties in the list on the left. You’ll see three “Object
positioning” options. The standard behavior is “Move and
size with cells”, but you can also create a chart that moves
around the worksheet but never resizes itself (“Move but
don’t size with cells”) and a chart that’s completely fixed in
size and position (“Don’t move or size with cells”).
For example, consider the chart shown in Figure 19-1. Its
top edge is bound to row 2, and its bottom edge is bound
to row 12. Similarly, its left edge is bound to column C, and
its right edge to column I. That means if you insert a new
row above row 2, the whole chart shifts down one row. If
you insert a column to the left of column C, the whole chart
shifts one column to the right.
Even more interesting is what happens if you insert rows or
columns in the area that the chart overlaps. For example, if
you insert a new row between the current row 10 and row