Automating Brackets, and Sum above Brackets in Excel Chart

Hello-

I have a few questions pertaining to my Chart in the attached.

1) Is there a way to incorporate a bracket on top of the bars, just covering the Green (unrealized Gain), and then just the Red (unrealized loss), as well as summing up on top of the bracket, without doing this manually. If not a bracket something similar for presentation purposes. The goal is to not have to manually do this part weekly.

2) In a legend, is there a way to have more than one for a column? For example, when I add in the Legend, it will just have the color Green for Series 1 (P&L column P). I would like to have Red, and Green for this series, so I can have a color for unrealized Gain, and Unrealized Loss. Right now the Red comes up but relates to the second horizontal axis.

3) For colors, when I do a format data series, and invert if Negative, it doesn't look like all the bars are selected. If I click on a bar, a few are not highlighting. I am not sure what is going on here.

Is there a way to have a sum above this line? Example $59.9 for Green, and (39.9) for Red?

Chart question2.xlsx Andy....I mad a few tweaks to my data. Is there a way to add in column q countries below the names they correspond to on the horizontal access? Also, How do I add a data label to the lines you created in the Middle of the line? If you could by any chance provide detailed instructions like you did with secondary horizontal axis. I'm sorry, I'm sure it takes a lot of time, but it really helps me to understand. I now have the secondary horizontal axis down.

Thank you

data label in middle should be the total at bottom of column S, and T.

I like how you set up countries below. I liked the legend titles previously, Total Unrealized gain, and Total Unrealized Loss. Is that possible to have and still have data labels? Both data labels right now are the same. Also, does that formula 15 still in place?

I am lost with the x, y, and error bar you crated. Now the line goes outside just what's in green or red. I do like the little bars at end of line though. The attached approach isn't helping me. I know how to do the simple chart stuff, but this goes beyond my head. Also, can I increase the font size for the avg% wgt, ctr, and country without increasing the font of the names of companies?