Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
chart on the left side of Figure 3-13. An area chart colors the area between
one line and the next. A 3-D area chart shows the area below each line as a
color slab, as shown in the chart on the right side of Figure 3-13.
Figure 3-13:
An area
chart with
two Series
fields shows
one area
in front of
the other
The quantity
of the Series
field is split
into several
lines or
areas (top).
As with bar charts, Access uses the Series field to split the amounts for each
line into several lower lines. The charts shown in Figure 3-13 use Vendor ID
as the Series field.
Making pie and doughnut charts
A pie chart shows how a total amount is split up by percentages. Access
needs to know what field contains the numbers you want to sum to make the
total amount, as well as what field contains the information that you want
to use to split this total into pie slices. A doughnut chart is a pie chart with
a hole in the middle, but you can specify more than one field, and you get a
concentric ring for each field. Pie and doughnut charts appear on the fourth
row of buttons in Figure 3-3, earlier in the chapter.
When you run the Chart Wizard, choose just two fields to include in the
chart, as shown in Figure 3-14:
The field below the sample pie chart is the one that contains the
numbers Access will sum to create the total pie. For a doughnut chart, you
should be able to specify more than one field and get a concentric ring
for each field. If you can’t specify all the fields in the Chart Wizard, you
can add them later; see “Changing which data is charted,” later in this
Search JabSto ::

Custom Search