Bar Chart not showing bars in desired order

[MayaE]

Hi!

I want my bar chart to display the bars in the following order from left to right: Very Satisfied, Somewhat Satisfied, Neither satisfied nor dissatisfied, Somewhat dissatisfied, and Very dissatisfied. Since my data is text, I went back to my Google Sheets where I have my raw data and added a column to number each data point in column B2:

Google Sheets column (this shows only part of the column as an example):

Google Sheets formula:

However, my bars are still not showing up in the order I specified in my Google Sheets formula. It looks like this:

• Dimension - set to the right survey question
• Metric - Record Count
• Sort - column from Google Sheets that quantifies my text data. I also have it set to Ascending order 

I have asked Gemini for help and have trouble shooted but no luck. I'm hoping someone can help me figure out what the underlying issue is. Thank you! 

[Beginner · Accepted solution]

Hi, 

For the column you use to sort, if it is aggregated as a SUM, it should be aggregated as AVG, or MIN, or MAX instead.

[Beginner · Accepted solution]

Hi, 

For the column you use to sort, if it is aggregated as a SUM, it should be aggregated as AVG, or MIN, or MAX instead.

[MayaE · Accepted solution]

Thank you so much, that worked! Appreciate your help 🙂