Knowledge Base

ACC: How to Create Fixed-Scale Charts in Reports and Forms in Microsoft Access 95 and Microsoft Access97

Article ID: 141607

Article Last Modified on 1/19/2007

APPLIES TO

Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

This article was previously published under Q141607

Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

When you create a chart in Microsoft Access, Microsoft Graph automatically adjusts the scale of the value axis for each record. This means the displayed range of values may vary from record to record. This article demonstrates how you can manually create a chart with consistent, fixed-scale values for every record.

NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95 version 7.0), RptSmp97.exe (for Microsoft Access 97), and Grphsm97.exe (for Microsoft Access 97). For information about how to obtain these sample files, please see the following articles in the Microsoft Knowledge Base:

145777 ACC95: Microsoft Access Sample Reports Available in Download Center

175072 ACC97: Microsoft Access 97 Sample Reports Available in Download Center

186855 ACC97: Microsoft Access 97 Sample Graphs Available in Download Center

MORE INFORMATION

To create a chart with fixed-scale values, follow these steps:

Open the sample database Northwind.mdb.
Create a blank report based on the Sales By Category query.
On the View menu, click Sorting And Grouping to open the Sorting And Grouping dialog box.
In the Field/Expression box, select CategoryName and set the GroupHeader property to Yes.
If the field list is not displayed, on the View menu, click Field List, and then drag the CategoryName and CategoryID fields to the CategoryName header section, and set the visible property to No for the CategoryID field.
Set the detail section's Height property to 0 (zero).
On the Insert menu, click Chart.
Insert the chart in the group header section. When the Chart Wizard starts, follow these steps:
1. Click the Queries button.
2. In the "Which table or query would you like to use to create your chart?," select the Sales By Category query, and then click Next.
3. Add ProductName and ProductSales from the Available Fields box to the Fields For Chart box, and then click Next.
4. When prompted "What kind of chart do you want?," click the bar chart button, and then click Next.
5. When prompted "How do you want to lay out the data in your chart?," click Next.
6. When prompted "If you want the chart to change from record to record, select the fields that link the document to the chart?," select CategoryId for both the report fields and the chart fields, and click Next.
7. When prompted "What title would you like for your chart?," click Finish.
Save the report as Report1, and then preview the report. Note that for each category, you see a chart of the total sales per product.

NOTE: The value scale of the horizontal axis varies from record to record.
View the Report1 report in Design view and double-click the chart object to open Microsoft Graph.
In Microsoft Graph, double-click the horizontal axis to open the Format Axis Patterns dialog box. Click the Scale tab.

In the Format Axis Scale dialog box, click to clear the first four Auto check boxes, type the following values, and then click OK:

        Minimum: 0
        Maximum: 45000
        Major Unit: 5000
        Minor Unit: 1000

On the File menu, click Exit and return to Microsoft Report1: Report.
Preview the Report1 report. Note that in the chart for each category, you see a consistent range of values from 0 to 450000 along the horizontal axis.

REFERENCES

For more information about creating a chart, search the Help Index for "charts, creating and inserting," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbhowto KB141607

Microsoft KB Archive/141607

Contents