Datasheet

Working with Charts
The following sections cover these common chart modifications:
•
Moving and resizing a chart
•
Converting an embedded chart to a chart on a chart sheet
•
Copying a chart
•
Deleting a chart
•
Adding chart elements
•
Moving and deleting chart elements
•
Formatting chart elements
•
Copying a chart’s formatting
•
Renaming a chart
•
Printing charts
NOTE
Before you can modify a chart, you must activate it. To activate an embedded chart, click
it. Doing so activates the chart and also selects the element that you click. To activate a
chart on a chart sheet, just click its sheet tab.
Moving and Resizing a Chart
If your chart is an embedded chart, you can freely move and resize it with your mouse.
Click the chart’s border and then drag the border to move the chart. Drag any of the eight
“handles” to resize the chart. The handles consist of three 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 Chart Tools➪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. Oddly, Excel does not provide similar controls to specify the top
and left positions of the chart.
To move an embedded chart, just click its border at any location except one of the eight
resizing handles. Then drag the chart to its new location. You also can use standard cut
and paste techniques to move an embedded chart. Select the chart and choose Home➪
Clipboard➪Cut (or press Ctrl+X). Then activate a cell near the desired location and choose
Part I: Chart Basics
26
05_044001 ch01.qxp 8/24/07 8:48 PM Page 26