Forum Discussion

darrenlow's avatar
darrenlow
Copper Contributor
Apr 26, 2020

Filter by question in Pivot Table

I'm building out pivot tables for a survey which is essentially a series of Likert based questions. So all 20 questions in this survey have responses from Strongly Disagree to Strongly Agree.    Es...
excel
Excel on Mac
Formulas and Functions
office 365
Qaiser_j's avatar
Qaiser_j
Brass Contributor
Jun 14, 2024

HI darrenlow 

 

The Likert Scale Chart is considered the most suitable visualization for the given data format. The platform described below supports three distinct data formats, enabling the creation of a Likert Scale Chart in just a few steps. Additionally, it offers a rich set of customization properties, enhancing the flexibility and utility of the chart.

 

I regularly create these charts with the following tool. Hope you will like it.

 

You can check here for Microsoft Excel & Office 365.

 

And if you are comfortable with Google Sheets, you can find it here.

 

Thanks

 

Likert Scale Chart for survey data

 

Few more charts

 

 

Resources