Create a bar chart

Try it!

Add a bar chart right on a form. 

1. In the ribbon, select Create > Form Design.

2. Select Insert Modern Chart > Bar  > Clustered Bar.

3. Click on the Form Design grid in the location where you want to place the chart. Resize the chart for better readability.

4. In the Chart Settings pane, select Queries, and then select the query you want.
   
   In the example, select QuarterlyExpensesQry.

5. To configure the chart, select options under the following sections. In the example, set:

   • Axis (Category) to "Quarter".

   • Values (Y axis) to "Expenses (Sum)".

   • Values (Y axis) to "Actual (Sum)".

   • Values (Y axis) to "Projected (Sum)".

6. Select Format > SumofProjected > Display Data Label.

7. To add a data label to a bar, select the Format tab in the Chart Settings pane, select "SumofProjected" under Data Series, and then select Display Data Label.

8. To format the numbers, Press F4 to open the Property Sheet, and then set:

   • Primary Values Axis Format to "Currency".

   • Primary Values Axis Font Color to "White".

   • Primary Values Axis Display Units to "Thousands".

9. To see the completed chart, right-click on the Form tab and select or Form View.

Want more?

Create a chart on a form or report

Access help & learning

All Access video training