Microsoft Office Tutorials and References
In Depth Information
Displaying Information with Charts
The Y-Axis setting
For vertical bar charts, drag the fields that determine the heights of the
bars — along with the values that appear up the left side of the chart — to
the Y-Axis setting. On horizontal bar charts, the Y-Axis fields control the
lengths of the bars and the values that run along the bottom of the chart.
In Figure 3-8, earlier in this chapter, the Y-Axis field contains the number of
items sold; it runs up the left side of the vertical bar chart and across the
bottom of the horizontal bar chart.
If you group dates together along the x-axis, you can specify how the values
are combined in the bars. If you want to graph sales by month, and your
record source has one record for each order, you may set the Y-Axis field to
be the Grand Total field of each order. Then you can specify how to
combine the values of the orders into months. You may want the total value of
all the orders for the month, or you may want the average value. The Y-Axis
setting in the Chart Wizard window indicates how the values are combined.
In Figure 3-4, earlier in this chapter, the Y-Axis setting contains the variable
SumOfQty, so Access sums up the Qty field for the orders in each month.
To change how Access combines the values of a Y-Axis field, double-click the
Y-Axis field to display the Summarize dialog box, as shown on the right side
of Figure 3-5, earlier in this chapter. Then specify how you want the values
for each time period to be combined — Sum, Avg (average), Min (minimum
value), Max (maximum value), or Count (number of records) — and click OK.
Unlike the X-Axis setting in the Chart Wizard, the Y-Axis setting can be more
than one field. If you drag more than one field to the Y-Axis setting, you see
a listing of the Y-Axis fields, as shown in Figure 3-9. For each Y-Axis setting,
you get a separate bar.
You can drag the same field to the Y-Axis setting twice. You may want to see
the count and the total of the same field, for example.
and one for