Try it!
Add a clustered column chart right into your Access form.
-
In the ribbon, select Create > Form Design.
-
Select Insert Chart > Column > Clustered Columns.
-
Click on the Form Design grid in the location where you want to place the chart.
-
In the Chart Settings pane, select Queries, and then select the query you want.
In the example, select EastAsiaSalesQry. -
To configure the chart, select options under the following sections. In the example:
-
Set Axis (Category) to "Quarter".
-
Set Values (Y Axis) to "East Asia Sales 2017 (Sum)".
-
Set Values (Y Axis) to "East Asia Sales 2018 (Sum)".
-
-
To trim text on the chart, select the Format tab in the Chart Settings pane and edit the Display Name.
-
To remove the chart title, In the ribbon, select Property Sheet and set Has Title to "No".
-
Note: While in the property sheet, you can choose various charts without starting over. For example, change the property Chart Type, to "Column Stacked", view the change, and then change it back to Clustered Column.
-
To see the completed chart, right-click the Form tab and select Form View.