Chart Reference Line

[JonathanT]

I am new to charts. I have a simple bar chart and I want to have a reference line so I can see how far over/under the values in the chart are. The chart is on a form. Should it be on a report? I also can't find anything online about how to add a reference line that makes sense to me. Any suggestions would be appreciated. Sample DB attached

[June7]

Are you using Modern Chart? I can't help with those. I can only use classic MSGraph which has a line-column custom chart. When I open your db I don't even see any chart. Should there be? If there were, I probably couldn't even open db because I use Access 2010.

Perhaps what I did can be applied to Modern Chart.

1. bind form or report to table BoodData and a textbox named tbxID bound to TestID

2. build a UNION query named DataUNION (I tested with only 5 data fields, add whatever you want):
SELECT CholesterolTotal, [HDL Cholesterol], [Non-HDL Cholesterol], [LDL Cholesteral], [CHOL-HDLC-Ratio], 1 AS SortOrder FROM BoodData WHERE TestID = Forms!Cholesteral!tbxID
UNION SELECT 150, 50, 100, 100, 3.5, 2 FROM BoodData;

3. build a chart of any type then modify to custom line-column and set RowSource to:
SELECT CholesterolTotal, [HDL Cholesterol], [Non-HDL Cholesterol], [LDL Cholesteral], [CHOL-HDLC-Ratio] FROM DataUNION ORDER BY SortOrder;

Chart can be on form or report.

Seem to have left the "l" out of word blood in table and query names.

Advise not to use spaces nor punctuation/special characters in naming convention.

[Bob Fitz]

I am new to charts. I have a simple bar chart and I want to have a reference line so I can see how far over/under the values in the chart are. The chart is on a form. Should it be on a report? I also can't find anything online about how to add a reference line that makes sense to me. Any suggestions would be appreciated. Sample DB attached

Where is the data or the "reference line" that you mention

[JonathanT]

The data is in the CholesterolQry and the chart is on the Cholesterol form

[JonathanT]

I want to put a reference line on the chart at 200 on the Y-axis

[June7]

Did you read post #2?

[isladogs]

June
Databases containing modern charts can be opened in earlier versions such as 2010. However, there will be an empty space where the chart should be.

[JonathanT]

June7, Thanks for the suggestion regarding naming conventions and misspellings. I have corrected those and inserted the updated DB. Is item 3 in your original post how to add a reference line in my current chart? Unless I'm really confused I don't think I need a new query to add a reference line

[Welshgasman]

Crossposted? https://www.utteraccess.com/topics/2065105?post=unread

[June7]

What I showed were steps for what I accomplished. Step 2 is a UNION query to add reference line data. If you don't think this is needed, what do you suggest?

Why do you have a GROUP BY clause when there is no aggregation of data?

[isladogs]

If you are using the older classic charts, just set the x-axis to cross at 200.

Unfortunately that isn't possible in a modern chart

[June7]

With Colin's suggestion also have set Maximum Y axis scale above 200. Then the bars start against the 200 line and stretch left toward zero. Odd looking and doesn't make sense to me.

[mike60smart]

Hi Jonathan

Is the Reference Line shown in the attached what you need?

[JonathanT]

mike60smart, that is not what I am looking for. I would like a straight horizontal line from left to right at level 200 of the Y axis

[JonathanT]

June7, I should have told you this earlier, I am using a Modern Chart.