Share via

Data Modelling Survey Data - Frequency Scale Question

Anonymous
2022-01-28T09:36:25+00:00

Hi all! I have a large dataset with survey responses from Google Forms. Among them are the responses from a question with responses on a 5 point frequency scale based on a time frame (More than 5 times; 4 - 5 times; 2 - 3 times; Less than 2 times; Never).

I am struggling to model in Excel to reflect what I want shown below:

Is there any way to recreate this graph in excel using Power Query? Do I need to create new values or rearrange/merge queries?

Please find a sample dataset here

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-01-28T13:55:32+00:00

Hi,

Thank you for querying in this forum.

We went through the post carefully. Since you want to show 5 point frequency scale for each type of restaurants on the chart, you will need to firstly use formula to calculate the frequency of each point and then insert column chart based on the calculated result.

Here is the file with chart:

https://forumspo2-my.sharepoint.com/:x:/g/personal/test_forumspo2_onmicrosoft_com/EURChZcKslhLosLPw8EiE-MBOzPoHrA9P8gKdxliB1gabw?e=hnxqvq

Hope you have a safe and happy new year!

Best regards,

Tina

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-28T14:48:27+00:00

    Hi,

    Many thanks for your time and effort! Tremendous work! Same to you!

    Sincerely,

    Jonathan Kramer

    Was this answer helpful?

    0 comments