Unable to create secondary axis in stacked chart

Copper Contributor

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:

alex_710_0-1713336681596.png

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

 

Hope someone can help me! :)

 

1 Reply

@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?