Related topics
Create charts
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Create charts

Create a combo chart

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Add  a combo chart right on your Access form.

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

  2. Select Insert Chart > Combo.

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

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

    • Axis (Category) to "Month (Month)".

    • Values (Y axis) to "Homes Sold (Sum)".

    • Values (Y axis) to "Average Price (Sum)".

  6. To combine the Line and Column charts into a Combo chart, set the primary and secondary series:

    • Select the Format tab and then select the arrow on the dropdown list, to see the two series.

    • The Column chart is already the primary series because under Data Series,"SumofHomes Sold" is listed first.

    • To make the Line chart secondary, select "SumofAverage Price" under Data Series.

  7. Under Format Data Series: SumofHomes Sold, set:

    • Plot Series On to "Secondary".

    • Chart Type to "Line".

    • Marker Shape to "Circle".

  8. To add clarity to the layout, in the ribbon, select Property Sheet, and then set the Axis Title to "Home Sales".

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

Want more?

Create a chart on a form or report

Access help & learning

Access video training

All Access video training

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!