topic Re: Display percentage on each part of 100% stacked bar chart in SAS Visual Analytics

Display percentage on each part of 100% stacked bar chart

max00d — Thu, 19 Feb 2015 09:52:55 GMT

This seems to be a pretty reasonable thing to want to do. However, I unable to display the percentages of each part of the stacked bar chart. The option to display values only shows 100% at the top of the chart. I have been searching everywhere for how to do this but I can see that 100% stacked charts are a new feature in 7.1 (the version I am using) - so perhaps this specific feature is not available?

Is is possible to display these values?

Thanks in advance

Re: Display percentage on each part of 100% stacked bar chart

MichelleHomes — Thu, 19 Feb 2015 10:12:00 GMT

Hi,

Have you checked the "show data labels" check box on the Properties tab for the bar chart and set the Grouping Scale option to "Normalize groups to 100%" as per the screenshot at the bottom of the thread - ?

The option becomes enabled if a data item is assigned to the Group role or if multiple measures are assigned to the Measures role.

Kind Regards,

Michelle

Re: Display percentage on each part of 100% stacked bar chart

max00d — Thu, 19 Feb 2015 10:55:36 GMT

Hi Michelle,

Thanks for reply. I can create the stack bar charts - what I cant do is set the individual percentages on the chart. When I select 'Show data labels' I get this:

It seems odd that there isn't an options to label the percentage each member of a group is contributing to this 100%.

Re: Display percentage on each part of 100% stacked bar chart

MichelleHomes — Thu, 19 Feb 2015 11:16:54 GMT

Thanks for the screenshot. Such a shame that the show data labels is only for the top of the bar not the segments within in and you need to hover over to get the values via a tooltip.

It does appear the feature you're after is missing. :smileyplain:

Kind Regards,

Michelle