Sorting Axis on Line Graph by Month Starting in August to July

Hi ironeagleuk ,

You don't need to put the sort column in the visualization, what you need to do is to pick the column you want to have sorted by a different column in this case the ShortMonth and then on the sort by column select the MonthSort column.

This will automatically sort your short month by the number and not by text. Be aware that when you do this you probably will need to take the column ShortMonth from the axis and replace it because some times the sorting does not take immediate effect on the visualizations that are already created.

When I do this ussually I hide the Sort column so I don't get confused building my visualizations.

ironeagleuk , Setup seems correct. I noticted both times you click on the "month sort" column and showing sorting on month sort column.

You need to click on the smallmonth column and sort on the month sort column.

Please check again. This what I am seeing in screenshots.