Unable to create secondary axis in stacked chart

Copper Contributor


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! :)


1 Reply


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?