This article shows you how to order data in a graph by changing the graph's
RowSource property to a query name rather than by using the SQL statement
that Microsoft Access generates.
The following steps demonstrate how to create a graph that will show all
the orders after 12/31/94, in descending order, in the Orders table in the
sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0):
- Open the sample database Northwind.mdb.
- Create the following new query based on the Orders table, and save
the query as GraphQuery:
Type: Select Query
Criteria: > #12/31/94#
NOTE: In Microsoft Access 1.x and 2.0, there is a space in the Ship
Name and the Order Date field names.
- Use the ChartWizard to create a new form based on GraphQuery. Select
both fields for the graph and click Finish.
- Switch to Form view. Note that the orders are sorted by the Ship Name
- View the form in Design view. Select the graph. If it is not displayed,
click Properties on the View menu to show the property sheet.
- Change the RowSource property of the object frame as follows:
Object: Object Frame
- Switch to Form view. Note that the orders are now sorted in descending
For more information about Microsoft Graph properties search the Help
Index for "charts," and then "Chart Control Properties" or ask the
Microsoft Access 97 Office Assistant.
Article ID: 99934 - Last Review: October 22, 2013 - Revision: 3.1
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
|kbnosurvey kbarchive kbhowto KB99934|