I’m charting medical test results and most tests have a high and low range.
I want the chart to show a straight line across the entire chart from data in B2/B3 for the normal high and low ranges.
I’m charting medical test results and most tests have a high and low range.
I want the chart to show a straight line across the entire chart from data in B2/B3 for the normal high and low ranges.
Hello,
Please try to keep main question short if possible.
Also, deleted my answer as I did not correctly read the question.
Sorry for the long question - my first time!
Something like the attached sample? I added helper columns for the max and min ranges and used a Column and Line chart with two lines.
If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it.That will help other people with the same question.
Thanks for the reply. Never thought of that. I was hoping for an easier way but your way will work. Thanks again.