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?