I have data from a feedback survey in an Excel spreadsheet. The questions are rated on your typical Likert scale.
1 Strongly disagree 2 Disagree 3 Neutral 4 Agree 5 Strongly agree
In the main sheet the responses are only recorded as the number. The corresponding text description is by itself in another sheet, like in a database.
So I have
Response ID Q1 Q2 etc 001 4 5 002 5 5
I'm creating a chart from the main sheet to display the results for each question, but there are no 1 or 2 responses, so the Pivot chart only goes from 3 to 5. Is there a way to still display 1 and 2 even though these values aren't found anywhere in the source data?
Also is there a way to make the label in the chart reference the text description i.e. change "1", "2", etc, to "strongly disagree", "disagree", etc?