Asymmetrical error bars on series bar chart for proportion confidence intervals

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!

Have you tried using Custom values for the error bars rather than Standard Deviation? The Custom Values is on the format dialog page for the error bars

You may need to apply a calculation to the existing values, subtracting the column height, to get the error bars to reflected intended positions

I'm not certain I understand what you are trying to, but here's what I did:

1) I need to calculate the length of each error bar, and these calculations need to be in cells that easily correspond to the chart data point they apply to. In this case, your data series are each in a 3 row x 1 column range (B3:B5 for series 1, for example), so my error bar calculations also need to be in a 3 row x 1 column range. I enter =ABS(E3-B3) into L3, =ABS(F3-B3) into M3, =ABS(G3-C3) into N3, =ABS(H3-C3) into O3, =ABS(I3-D3) into P3, and =ABS(J3-D3) into Q3. Copy/paste/fill this row down into rows 4 and 5.
2) In the chart, select the series 1 error bars -> format error bars -> custom value -> and enter/choose M3:M5 for the positive error bar values and L3:L5 for the negative error bar values. Repeat with the corresponding columns for series 2 and series 3.

If I have understood what you are trying to do, that should be close to what you want. If I've misunderstood, help us understand what you want to do and we should be able to help get the desired effect.