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. 

3 Replies

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



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?



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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies