Page 404 - Excel 2007 Bible

25_044039 ch19.qxp 11/21/06 11:10 AM Page 361
Getting Started Making Charts
Moving and resizing a chart
If your chart is an embedded chart, you can freely move and resize it with you mouse. Click the chart’s bor-
der and then drag the border to move the chart. Drag any of the eight “handles” to resize the chart. The
handles are the black dots that appear on the chart’s corners and edges when you click the chart’s border.
When the mouse pointer turns into a double arrow, click and drag to resize the chart.
When a chart is selected, you can use the Format ➪ Size controls to adjust the height and width of the
chart. Use the spinners, or type the dimensions directly into the Height and Width controls.
You also can use standard cut and paste techniques to move an embedded chart. In fact, this is the only way
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 choose Home ➪ Clipboard ➪ 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, it 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 Tools ➪
Location ➪ Move Chart to display the Move Chart dialog box.
Copying a chart
To make an exact copy of an embedded chart, press and hold down the Ctrl key. Click the chart and then 19
drag the mouse pointer to a new location. 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 ➪ Clipboard ➪ 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, it will
be linked to the data in the original workbook.
Deleting a chart
To delete an embedded chart, press Ctrl and click the chart (this selects the chart as an object). Then press
Delete. When the Ctrl key is pressed, you can select multiple charts, and then delete them all with a single
press of the Del key.
To delete a chart sheet, right-click its sheet tab and choose Delete from the shortcut menu. To delete multi-
ple chart sheets, select them by pressing Ctrl while you click the sheet tabs.
Adding chart elements
To add new elements to a chart (such as a title, legend, data labels, or gridlines), use the controls in the
Chart Tools ➪ Layout group. These controls are arranged into logical groups, and they all display a drop-
down list of options.
Moving and deleting chart elements
Some of the elements within a chart can be moved. The movable chart elements include the titles, the leg-
end, and data labels. To move a chart element, simply click it to select it. Then drag its border. The easiest
way to delete a chart element is to select it and then press Delete. You can also use the controls in the Chart
Tools ➪ Layout group to turn of the display of a particular chart element. For example, to delete data
labels, choose Chart Tools ➪ Layout ➪ Labels ➪ Data Labels ➪ None.

361