Microsoft Office Tutorials and References
In Depth Information
Resizing a chart
Before you can modify a chart, the chart must be activated or selected. To select an embedded chart, click it.
Doing so activates the chart and selects the element that you click. To select a chart on a chart sheet, just click its
Resizing a chart
If your chart is an embedded chart, you can freely resize it with your mouse. Click the
chart’s border. Square handles appear on the chart’s corners and edges. Move the mouse
pointer over a handle and when the pointer turns into a double arrow, drag to resize the
When a chart is selected, choose Chart Tools
Size and use the two controls to
adjust the height and width of the chart. Use the spinners or type the dimensions directly
into the Height and Width controls.
Moving a chart
To move an embedded chart to a different location on a worksheet, click the chart to
select it, move the mouse pointer over one of its borders, and then drag. You can use
standard cut-and-paste techniques to move an embedded chart. In fact, this is the
only way to move a chart from one worksheet to another. Select the chart and choose
Home ➪ Clipboard ➪ Cut (or press Ctrl+X). Then activate a cell near the desired location and
Paste (or press Ctrl+V). The new location can be in a different
worksheet or even in a different workbook. If you paste the chart to a different workbook,
the chart will be linked to the data in the original workbook.
To move an embedded chart to a chart sheet (or vice versa), select the chart and choose Chart
Move Chart; the Move Chart dialog box appears. Choose New Sheet
and provide a name for the chart sheet (or use the Excel proposed name).
Copying a chart
To make an exact copy of an embedded chart on the same worksheet, click the chart’s
border, press and hold the Ctrl key, and drag. Release the mouse button, and a new copy of the
chart is created.
To make a copy of a chart sheet, use the same procedure, but drag the chart sheet’s tab.
You also can use standard copy-and-paste techniques to copy a chart. Select the chart (an
embedded chart or a chart sheet) and choose Home ➪ Clipboard ➪ Copy (or press Ctrl+C).
Then activate a cell near the desired location and choose Home
Paste (or press
Ctrl+V). The new location can be in a different worksheet or even in a different workbook.