ACC1x: Creating Fixed-Scale Graphs in Forms and Reports (1.x)
ID: Q109737
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1
-
Microsoft Graph, version 3.0
SUMMARY
When you create a graph in Microsoft Access version 1.x, Microsoft Graph
version 3.0 automatically adjusts the scale of the value axis for each
record. This means that the displayed range of values may vary from record
to record.
This article demonstrates how to create a graph with consistent, fixed-
scale values for every record.
MORE INFORMATION
The following steps demonstrate how to create a graph with fixed-scale
values:
- Open the sample database NWIND.MDB.
- Create a new blank report based on the Sales By Category query.
- From the View menu, choose Sorting And Grouping. In the first cell of
the Field/Expression column, select Category Name, and then set the
GroupHeader property to Yes.
- From the field list, drag the Category Name field to the Category Name
header section.
- Set the Height property of the Category Name section to 2 inches.
- Set the Height property of the Detail section to 0.
- From the Toolbox, choose the Graph tool and create a new graph in the
empty area below the Category Name field in the Category Name header
section.
- In the "Which type of graph do you want?" box, select Sales By Category
as the data source. Choose the horizontal bar graph button (top row,
second from the left). Make sure the Sum option button is selected,
then choose the Next button.
- In the "Which fields contain the data you want to graph and use for
labels?" box, select Product Name and choose the ">" button. Then,
select Product Sales and choose the ">" button. Choose Next.
- In the "Link the graph to the report?" box, choose Yes.
- In the "Which field(s) will link the graph to the form?" box, make sure
Category Name is selected in both the Form Fields and Graph Fields
boxes, then choose the "<=>" button. Choose Next.
- In the "What title do you want for your graph" box, choose the Design
button.
- Save the report as Report1 and then preview it. Note that for each
category you see a graph of the total sales per product, and that the
value scale of the horizontal axis varies from record to record.
- View the report in Design view and then double-click the graph object.
- In Microsoft Graph, double-click the horizontal axis to open the Axis
Patterns dialog box. Choose the Scale button.
- In the Format Axis Scale dialog box, clear the following check boxes
and enter the following values, then choose OK:
Minimum: 0
Maximum: 45000
Major Unit: 5000
Minor Unit: 1000
- From the File menu, choose Exit And Return To Microsoft Access. When
you are prompted to update the graph in Microsoft Access, choose Yes.
- Preview Report1. Note that in the graph for each category you see a
consistent range of values from 0 to 450,000 along the horizontal
axis.
REFERENCES
Microsoft Graph "User's Guide," version 3.0, Chapter 3, "Formatting
the Axis Scale," pages 87-92
Keywords : kbtool IntpGrph
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbinfo
|