This section covers some common chart modifications:
Moving and resizing charts
Copying a chart
Deleting a chart
Adding chart elements
Moving and deleting chart elements
Formatting chart elements
Before you can modify a chart, the chart must be activated. 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.
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 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 ...