Text data for creating a chart
tida189
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I received the responses from a form generated automatically in text in Excel (completely agree, somewhat agree, somewhat disagree, not at all agree)
However, I need to create graphs to show these responses. But I don't know how to convert them into numbers??
I should make one graph per question or theme (set of questions)
And then create a radar chart that would include the 6 themes.
Is this possible??
Configuration: Windows / Edge 14.14393
I received the responses from a form generated automatically in text in Excel (completely agree, somewhat agree, somewhat disagree, not at all agree)
However, I need to create graphs to show these responses. But I don't know how to convert them into numbers??
I should make one graph per question or theme (set of questions)
And then create a radar chart that would include the 6 themes.
Is this possible??
Configuration: Windows / Edge 14.14393
2 réponses
Hello
What you need to do first is to count each type of response by question, which is possible with COUNTIF in principle
It all depends on how your answers are arranged (in rows, in columns, on one or several sheets...)
Post an example of your file on my-partage.fr, copy the created link and come back to paste it here, then we can tell you how to proceed
Best regards
Via
What you need to do first is to count each type of response by question, which is possible with COUNTIF in principle
It all depends on how your answers are arranged (in rows, in columns, on one or several sheets...)
Post an example of your file on my-partage.fr, copy the created link and come back to paste it here, then we can tell you how to proceed
Best regards
Via
Hello
not sure I understood but try to adapt
=COUNTIF(B:B,C1) to drag down the range in C
you get in D the number of responses of each type and you can set up a chart with C and D
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
not sure I understood but try to adapt
- the questions in A
- the answers in B
- in C the exhaustive list of possible answers
- in D the formula
=COUNTIF(B:B,C1) to drag down the range in C
you get in D the number of responses of each type and you can set up a chart with C and D
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!