can I get help rearranging the columns in a google chart?

[Amy Smoker]

Hello,

I have ten charts all from then different questions. Each chart has the same lickert scale types responses : always, sometimes, usually, never. The problem I'm having is that each chart is putting those responses into different order. I'd prefer that they always go in 'order' as I wrote them above. However, they sometimes are in order, sometimes not. I can't see a pattern (it is not always alphabetical, nor in order of number of responses from most to least).

Can someone tell me how to manually rearrange the columns after creating the chart? Is there another option? I do not use charts very often and would consider myself a beginner.

[Ray Thomas]

Are you using a Google Sheet to hold the chart? If you are you can use ORDER BY in the query to get the table. The help for that is at https://developers.google.com/chart/interactive/docs/querylanguage#order-by there's more at https://developers.google.com/chart/interactive/docs/spreadsheets and here's an example form one of my charts:

var queryString = encodeURIComponent('SELECT A, B, C, D, E order by A');

var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1kjOTQMAlWc-j6G_XfFUJIzAxuvmyxygQh0q1Dpn4oRU/gviz/tq?gid=0&headers=1&tq=' + queryString); 

You can also sort the table using one of the sort options from the help at https://developers.google.com/chart/interactive/docs/gallery/table and see https://stackoverflow.com/questions/23764280/sort-in-google-table-chart