Working with Charts

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

  • Printing charts

Note

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.

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 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 ...

Get Office 2007 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.