Hello, I have a bar chart that I am trying to add confidence intervals to. The confidence intervals are based on proportion and are asymmetrical. I can add the confidence intervals as error bars, and I can add them if they are asymmetric, but since my data is grouped, it creates a series, and excel will not let me add a confidence interval to only one of the bars in the series. It applies the CI to every bar even in a different group, even though they have different CI's. Is it possible for excel to even do this? Do I need to arrange my data differently? Can I still keep the same chart format while removing the series aspect?
I included the excel file so it is easier to understand what I am getting at. The columns 1, 2, and 3 contain the data and are grouped by the columns and rows. A, B, and C, are all the same color bar. I would really prefer if they could stay grouped by the column and row so that they stay the same color and keep the legend, but I could probably edit the color of each bar to match if I need to. The confidence intervals are in the 1L 1H etc columns. L representing the lower value and H representing the higher value. I color coded them so you could see which CI corresponds to which data point. Currently the error bars are wrong so disregard those. Basically, I need each bar in the graph to have a different error bar despite the bars being grouped together. Any help is appreciated! Thanks!
Bookmarks