Forum Discussion

DP385's avatar
DP385
Copper Contributor
Oct 27, 2024

Feedback: Please visualize multiple choice questions in a barchart instead of pie chart.

When using MS Forms for surveys, I was surprised that the answers to multiple-choice questions are visualized as a pie chart. This is not an appropriate visualization for this type of question and is very misleading - therefore, it is not used by default in similar tools.

To explain the problem, let's take for example the following data

Participant_IDChoices
1[A;B;C;D]
2[A;B;D]
3[A;C;E]


By Default, MS-Forms visualizes this in a pie chart which would look as follows:
A:30%; B:20%; C:20%; D:20%; E:10%.

This is very misleading, since 100% of respondents chose A, 66% chose B,C,D and 33% chose E.

For this reason, other survey tools visualize MultipleChoice Questions as Barchart, with one bar for each option.
E.g. in this case 5 bars:
A : 100% of respondents
B : 66% of respondents

C : 66% of respondents

D : 66% of respondents

E : 33% of respondents.


It would be great, if MS Forms could do this to - because the current pie-chart is not helpful and misleading.

I am sharing my feedback here, since the "feedback" option is greyed out.
If anyone can forward this to the product team, I would be very thankful 😊

Resources