Forum Discussion
95% Confidence Interval to Bar Graph
I am trying to add 95% confidence intervals to my bar graph in excel. I have 5 categories, each with one number (that I was told are averages) and I was given an upper and lower confidence interval f...
In general it works, standard 95% or custom (could be array constant or cells range)
- Dear Sergei, how do you make this chart of yours (so that category labels are on the vertical axis and the values are charted against the horizontal axis)? In 2022 Excel 16.66 for Mac this seems impossible, or I am missing the feature.
I tried to input the numbers directly as shown in the image SergeiBaklan , but the error bars are way off. Am I doing something wrong?
Hi Julie1 ,
But it shows correctly. Let take Q1 bar:
value = 18.28
LCI =11.69, thus it shows 18.28-11.69=6.59
UCI=27.42, error bar shows 18.28+27.42=45.70
