Jul 01 2021 01:53 PM
I want to graph blood Hemoglobin using a chart in Excel 365. The first data point I have is 9. The normal range of Hemoglobin is 13 to 17 and I want "error bars" to show at 13 and 17 so I can see when the values of Hemoglobin entered in the workbook over time enter into the normal range. As far as I can see, Excel only allows error bars above and below the current data point and doesn't allow one to make error bars that are above (or below) the current data point value. Please see attached mock-up of how I think this should look.
Thanks,
Don
Jul 01 2021 03:07 PM