Forum Discussion
Snoopdon
Jul 01, 2021Copper Contributor
How to make "error bars" that are above the value of a data point
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 whe...
mtarler
Jul 01, 2021Silver Contributor
I suggest adding a second data series that has the 'average' expected value and then add the error bars to that second data series and set the line and point formatting of the series to 'None' so all you will see are the error bars.