Share via

Adding a threshold line to a bar chart in Access

Anonymous
2024-05-24T09:15:28+00:00

Hi,

I have created some graphs in Access so users can visualise the data they have entered. I have a bar chart which shows scores on a clinical measure over time (appointment date on the X axis and measure score on the Y axis). I want to be able to add a line to the graph which shows the clinical threshold so users can see whether their clients scores are above or below the threshold. The threshold line would always be the same. Does anyone know how this can be added in Microsoft Access?

Thank you!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2024-05-24T15:55:21+00:00

    @Sophia: you're showing the classic ActiveX graph control, which MSFT abandoned a few years ago in favor of Modern Chart.
    I cannot recommend the old control for new development. It is dead, dead, dead.

    0 comments
  2. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2024-05-24T12:58:24+00:00

    Create a table to store the threshold values and include the table in the chart’s row source query. 

    SELECT [all regular fields], threshold

FROM [regular source], tblThresholds

WHERE Measure = "Heart Rate"

    Then just plot the threshold value.

    0 comments
  3. Anonymous
    2024-05-24T12:57:07+00:00

    Hi abin23,

    To add a threshold line to a bar chart, please refer to these steps:

    1. Open your report or form containing the bar chart in Design View;
    2. Right-click the bar chart -> Chart Object -> Edit;
    3. Add a new column named ‘line’ with the same threshold value 50:

    1. Right-click the line series -> Add Trendline…

    1. Ensure that the Based on series is ‘line’, then click OK:

    1. Right-click the line series ->Format Data Series…

    1. Set border and Area to None, click OK.

    1. Click line in the legend area and press the DEL key

    Finally, the bar chart with line threshold will be:

    Best Regards,

    Sophia

    0 comments