making stacks with percentage

Hi,

In below thread I found a chart which I also want to use, however below example only has 2 variables (current vs. non current). I increased the number of variables to 7, but I cant figure out how to fill the helper tables correctly. The helper tables should determine the position and size of the y error bars.

http://www.excelforum.com/search.php?searchid=1442552

I have attached the excel file. Any tips ?

The chart is built in the same way you just need to adjust the formula for calculating Y positions and errorbar lengths