Stacked bar chart

[#1]

I wonder if anyone can help me with a stacked bar chart to show overall satisfaction?

The column in my data has the responses: Satisfied, Neither, Dissatisfied.

I just want to show the % of each response in a bar (totalling 100%). This is easy to do as a pie chart but I can't work out how to do it as a bar chart.

Many thanks.

[#2]

In the property of chart, tab Expression, check Relative

[swuehl · Accepted solution]

So you want a single, total and stacked bar for the responses?

There is something special with a stacked bar chart, you can't use it with just one dimension (e.g. ID) and one expression (e.g. count(Responses) ).

But you can leave out the dimension and use three expressions:

=count({<Response = {Dissatisfied}>} Item) / count(Item)

=count({<Response = {Satisfied}>} Item) / count(Item)

=count({<Response = {Neither}>} Item) / count(Item)

Then use a stacked bar style in style tab and check Show in Percent in Number tab.

Hope this helps,

Stefan

[#4]

Thanks!!