Unable to create secondary axis in stacked chart

Hello!

First post here 🙂 I have a stacked chart for some datasets over different time periods and areas. For some bars, the stacked bar is so low value that I would need a secondary axis. But I don't get it to work. Becuase I can only choose the data that the stacked bar is "made of" on the secondary axis, and not the total stacked bar. 

As this:

So is it possible to get the small small stacked bars to the right, on a secondary axis?

Hope someone can help me! 🙂