Adding a 3rd bar on x-axis, and 3rd error bar

[cartica]

Hi-

What is the best way to add in column AG as a bar next to the current bars. I would want one solid color, and I don't need it brown up between positive, and negative. Also, I would want a 3rd error bar underneath for FX P&L. Looks like if I try to add a new data series they default to xy ranges, and forgot how to reverse. Please see attached example.

Chart question.xlsx

Thanks

[Glenn Kennedy]

Is this what you had in mind for the first part?

Can you explain a bit more about what you want regarding the error bars?

[cartica]

Sorry, that is not what I'm looking for. You just ignored what my graph was previously. It should be in same format is before. I'm just adding to it as I described above. Thank you.

[Glenn Kennedy]

Is this any better?

[cartica]

How is that like the chart I originally posted? Thanks for trying though.

[cartica]

I'm sorry. Something happened to graph. I will have to repost.

[cartica]

It may be that I am opening with my phone. I'll have to take a look when I get to work. Thamks

[Glenn Kennedy]

With respect, it is identical to your original chart, with the addition of an extra dataset. I intentionally left your original graph to the left of the one that I modified. I am sorry if I have not been able to help. It is clear that either I have misunderstood what you want, or you have not explained your requirement with sufficient clarity.

Edit: I posted this before I saw the OP's posts 6 & 7.

[cartica]

Thank you Glenn. That is exactly what I was looking for. I have re-attached with the error bar I have added. Can you walk me through how you added the columns in blue.

Thank you
Chart question.xlsx

[Glenn Kennedy]

Here's thew whole saga...

[cartica]

Glenn. This looks different than the one I posted in. The columns slightly overlap in your example, where previously they didn't.