Re: Custom labels not showing on 100% stacked bar ...

kc89 · ‎10-02-2023

Hello,

I've tried searching the forums for support on this but couldn't find anything.

I'm plotting survey data where I want to show the level of agreement with four different statements split by two groups - those who had support ('Yes') and those who didn't ('No'). A 100% stacked bar with small multiples is great to visualise this, however I want to be able to show the number of responses rather than % of responses in the data labels, because the base sizes can be quite small and I don't want the %s to be misleading. I don't want to use a standard stacked bar because the number of people in the Yes/No groups won't always be equal and therefore it would make the chart more difficult to interpret.

I've tried using a custom label where I add in 'Count of ID' (the same value used in the chart itself) however the labels don't appear. I read that this could be to do with the labels not having enough room to show, but I've tried making the label text as small as possible / increasing the size of the chart to fill the whole page which still didn't work. Similarly, I tried adjusting the small multiples to only show in 1 column and 1 row so one pair of stacked bars filled the entire page and you had to scroll down to see the others, and that didn't work. The only thing that worked to show the labels was removing the small multiples but this renders the chart meaningless. I've added images below to show the different things I've tried.

I'd really appreciate any help with this! Thank you in advance.

100% stacked bar original, before custom labels added. % labels showing

Custom labels added. Labels not showing

Custom labels added, small multiples amended to display in 1 row x 1 column so the bars for each statement fill the whole page. Labels not showing

Custom labels added, small multiples removed. Labels showing, but chart is meaningless