Unable to create secondary axis in stacked chart

[alex_710]

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! 🙂

[#2]

@alex_710 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?