Moving and Resizing a Chart

You can move or resize an embedded chart after you select it. If you've created a chart as a new sheet instead of an embedded object on an existing worksheet, the chart's size and location are fixed by the sheet's margins. You can change the margins to resize or reposition the chart. You can also move your embedded chart off the original worksheet and onto another worksheet. When resizing a chart downward, be sure to watch out for legends and axis titles.

Move an Embedded Chart

Select a chart you want to move.

Position the mouse pointer over a blank area of the chart, and then drag the pointer to move the outline of the chart to a new location.

Release the mouse button.

Resize an Embedded Chart

Select a chart you want to resize.

Position the mouse pointer over one of the handles.

Drag the handle to the new chart size.

Release the mouse button.

Did You Know?

You can avoid clicking a chart's handle . Clicking and dragging a chart's handle resizes the chart. If you accidentally resize a chart, press Ctrl+Z to undo the change.