Best way to display survey results

[mtrevisiol]

Hi everyone,

I'm asking you the best way to represent the results of a company survey.

I've got a questionnaire with 10 questions; each questions has three possible answers, but only one choice.

I would like to represent, by means of pie charts, the distribution of the answers to each question.

This is the best result I've achieved using the classical pie chart:

but in my opinion this is not the best: the legend does not show all three possible values for the answer (although I have flashed 'Show items without data'), graphs are not aligned...do you know of any alternatives, even involving the use of custom visual objects?

Thank you so much.

[Ritaf1983 · Accepted solution]

Hi @mtrevisiol 

Assuming the goal is to help readers easily understand survey results, the pie chart issue in the image is far more than just a cosmetic structural problem.

Readers' brains will have to deal with:

1. Color overload and interpretation because each pie chart has its own colors.

2. Comparing slice areas, which also presents its own challenges.

3. There is a chance that not everything will fit on one page.

Therefore, I propose switching to a visualization that allows for easy size comparison.

(Rectangles stacked on top of each other are much easier to compare than pie chart slices)

It does not require color variation,

It is clean and compact in terms of real estate, and it allows for easy work with text.

This involves a combination of a table and a chart that can be achieved using a matrix and conditional formatting

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[mtrevisiol]

Yes, I think you're right. Rectangles are the most compact and easy to read solution. many thanks!

[Ritaf1983]

Happy to help 🙂