I have a set of data where the order the rows appears is meaningful but is not alphabetic. The source file is a CSV and has the data in the right order, but when I create my charts the rows are always put in alphabetical order.

Specifically, I have a column "opponent" that I drag to the Columns part of the chart definition. I click on the down arrow and Sort... and make sure "Sort by" is "Data source order". However the "Sort order" section has to have either Ascending or Descending selected which seems to override the data source order. So I'm unable to get the order to be the order in my dataset.

Is there a way to fix this? Or do I need to add a new column to my dataset that specifies the order numerically that I can sort on?