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

[cwollett]

I realize this is a year later, but I've been searching for a good way to display some survey data that has data about each option, has a graphical component to be less boring, and is still accessible (trying to stay away from custom deneb). This was a really cool implementation that I think checks all my boxes. So kudos again for throwing this idea out there with an example attached.

[Ritaf1983]

Hi @cwollett 

Thanks so much for the thoughtful comment – it honestly made my day!
For me, it was like solving a puzzle – finding a way to make something easy to read and not too hard to implement 🙂
Really appreciate you coming back to share this a year later – it means a lot!

[mtrevisiol]

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

[Ritaf1983]

Happy to help 🙂