How Do I Create a fancy Tornado Chart with data labels?

[nickFe]

Hi,
I've adapted a friend's tornado chart to exactly how I want it.
The problem is it only has 4 items in the chart.

I want to recreate the same chart with 5,6,7,8,9,10,11,12,13,14,15 items so that I have a template ready for whenever I need one.

I can't figure out how he has displayed the data labels because they come from a different series to where they actually sit on the chart
(it is a stacked chart with hidden bits and pieces so the labels are actually correct)

Does anyone have any ideas on how this chart was created? (Or how to recreate it in a simpler way that people like myself could recreate?

I have attached the file, feel free to use it if you like it :-)
It's great for presenting NPV sensitivities!

[Andy Pope]

I have tweak 1 or two formula to dynamically calculate label spacing of the RedLineLabel series.

You should be able to extend or delete the formula.

Then select the chart and use the up arrow to cycle through the chart elements. When you reach a series use the bounding boxes to adjust the ranges covered by the series. Either extend or reduce the ranges.