Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
The Series setting
Unlike the X-Axis and Y-Axis settings, the Series setting in the Chart Wizard
is optional; most charts leave this setting blank. The field used for the Series
setting tells Access how to break down the bars (or columns, cones, or
pyramids) into a group of smaller bars.
If you graph sales by month, each bar normally shows the total of the sales
records for that month. If you drag a field to the Series setting, Access
divides the bar for each month into several bars according to the value of
the Series field. If you set Series to a field that represents which vendor sold
you the product, you get a group of bars for each month, with one bar for
each vendor.
Figure 3-10 shows the Chart Wizard settings for a graph that separates sales
by Vendor Code, and Figure 3-11 shows the resulting chart. (There are four
different vendors.)
Figure 3-10:
The
Vendor
Code field
is used as
the Series
setting,
which
splits each
month’s
sales into
separate
bars for
each
vendor.
If you choose three or more fields to use in your chart, the Chart Wizard
usually guesses that you want to use one of the fields as the Series setting. But
for most charts, you use only the X-Axis and Y-Axis settings; just leave the
Series setting blank. If the wizard puts a field there, drag it back over to the
parking-area list of fields on the right side of the wizard’s window.
Making line and area charts
Line and area charts work similarly to bar charts. A bar chart draws a bar
(or other shape) for each value of the X-Axis series, with its height
determined by the Y-Axis series. A line chart works the same way, but instead of
drawing a bar, Access draws a dot where the top of the bar would be and
Search JabSto ::




Custom Search