Create charts

Create a column chart

Your browser does not support video.

Try it!

Add a clustered column chart right into your Access form.

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

  2. Select Insert Chart > Column > Clustered Columns

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

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

    In the example, select EastAsiaSalesQry.

  5. 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)".

  6. To trim text on the chart, select the Format tab in the Chart Settings pane and edit the Display Name.

  7. To remove the chart title, In the ribbon, select Property Sheet and set Has Title to "No".

  8. 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

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

Want more?

Create a chart on a form or report

Access help & learning

Access video training

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×