Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
When you click Next, the wizard displays a small version of the chart, as
shown in Figure 3-4. The chart shows three labels: the Axis (the
horizontal x-axis on most types of graphs), the Data (usually, the vertical y-axis),
and the Series (usually, fields displayed in the chart as bars, lines, or
The wizard guesses which field is on the x-axis, which is on the y-axis,
and which fields are the series. Sometimes, its guess makes sense; at
other times, it produces a chart that doesn’t make sense or just doesn’t
show what you had in mind.
8. Drag fields to the chart on the left side of the wizard window, and tell
the wizard how to use the fields you’ve selected (refer to Figure 3-4).
The fields that you choose appear as buttons on the right side of the
window. Unused fields are parked over there. Fields that appear on the
chart have only a shadowy box in that parking area, and their buttons
appear on the chart as follows:
You specify how to use each field by dragging its field name to the
parking area or to one of these three locations on the sample chart. If Access
guessed wrong about how to use the fields, drag the field names around
to more sensible locations. Don’t worry about how the field names
appear; you can fix the legends on the chart later.
How the Axis, Data, and Series settings work depends on the type of
chart you’re creating. The next four sections describe how to specify
fields for bar, line, area, and other types of charts.
You don’t have to use all the fields; you can leave some languishing in
the parking area.
on the chart.