Skip to Main Content
Excel 2003 for Starters: The Missing Manual
book

Excel 2003 for Starters: The Missing Manual

by Matthew MacDonald
October 2005
Beginner content levelBeginner
400 pages
8h 53m
English
O'Reilly Media, Inc.
Content preview from Excel 2003 for Starters: The Missing Manual

Basic Tasks with Charts

Unlike the orderly rows of numbers and labels that fill most worksheets, charts float above your data, locked inside special box-like containers. To best take advantage of these chart boxes, you need to understand a little more about how they work.

Moving and Resizing a Chart

When you insert a chart into an existing worksheet, it becomes a floating object, hovering above your worksheet. Depending on where Excel puts it, it may temporarily obscure your data. The chart box doesn't damage your data in any way, but it can end up hiding your worksheet's numbers and text (both onscreen and in your printouts).

Note

To remove a chart in one fell swoop, just select it with the mouse and press the Delete key.

The solution is to learn to grab hold of these floating boxes and place them where you really want them. The process is pretty straightforward:

  1. Click once on the chart to select it.

    Notice that when you select a chart, Excel highlights the worksheet data the chart uses, as shown in Figure 9-4. At the same time, the Chart toolbar springs into visibility at the top of the Excel window.

    Before you can move a chart, you must first select it. You know you've selected the whole chart when Excel outlines the worksheet data with a colored border and squares appear along the periphery.

    Figure 9-4. Before you can move a chart, you must first select it. You know you've selected the whole chart when Excel outlines the worksheet data with a colored border and squares appear along the periphery.

    Make sure you click the edge of the chart or on a blank space inside the chart, and ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Show Me Microsoft® Office Excel 2003

Show Me Microsoft® Office Excel 2003

Steve Johnson - Perspection, Inc.

Publisher Resources

ISBN: 0596101546Supplemental ContentErrata Page