Try it!
Add a line chart right on an Access form.
-
Select Create > Form Design.
-
Select Insert Chart > Line > Line.
-
Click on the Form Design grid in the location where you want to place the chart. Resize the chart for better readability.
-
In the Chart Settings pane, select Queries, and then select the query you want.
For example, select RainMeasuresQry. -
To configure the chart, select options under the following sections. In the example set:
-
Axis (Category) to "Day".
-
Values (Y axis) to "Daily Rainfall" and change the aggregation to "None".
-
Values (Y axis) to "Particulate" and change the aggregation to "None".
-
-
In the ribbon, select the Property Sheet and set Back color to "Access Theme 1".
-
In the Format tab, for each data series under Data Series, set the line weight to 3.5 and turn on Display Data Label.
-
To see the completed chart, right-click on the tab and select Form or Report View.