X-axis sort order breaks when adding legend in scatter chart

Hi there, I'm trying to use a scatter chart with a categorical x-axis (i.e. it's more of a dot-plot than a scatter chart). I have sorted the values in my x-axis by an "order" column like below:   ...