• From the menu, select Insert / Chart...
• Create a new Form or Report and select Chart Wizard

Create a new query for the Row Source property where the first returned value will be used to label the x-axis and each additional field will be a series in the graph.

When displayed as an xy plot, the first field will be the x-values and each additional field will represent a series.

SELECT Gas.Date, Gas.[Price/Gal]
  FROM Gas
 ORDER BY Gas.Date;

Now you need to double click the chart component - this starts Microsoft Graph. From the menu, select Data / Series in Columns. (On my system, the default is Data / Series in rows.)

Series in Columns causes each value in the select statement to be treated as a series.

More Details

URL: http:// cpcug.org / user / clemenzi / technical / Databases / Graphs.html