95% Confidence Interval to Bar Graph

New Contributor

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 for each number. However, excel doesn’t recognize these as CIs since they were not calculated in excel (and I don’t have the raw data).

 

I tried to add custom error bars but the upper and lower CIs were always off by about 1. I don’t think this method is working, is there another way to do it in excel? Am I doing something wrong?

 

Any assistance would be appreciated. Thank you. 

4 Replies

In general it works, standard 95% or custom (could be array constant or cells range) 

image.png

 

I tried to input the numbers directly as shown in the image @Sergei Baklan , but the error bars are way off. Am I doing something wrong?

Capture.PNGCapture1.PNGCapture2.PNG

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

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.