Forum Discussion
Scatter chart X axis sorting issue
Hi Ritaf1983 Any suggestion or solution over this?
Hi Krushnab85
Apologies for the delayed response, I had a busy day.
The sorting issue is caused by the clustering of shipping days.
Without it , the sort order is correct:
The last two points are outliers in terms of the clustering that the graph performs, and that's why you're not able to sort properly, unfortunately, there is no way to fix it.
In the past, we had a categorical scatter plot for these purposes, but unfortunately, it no longer exists.
You can try to replace this graph with a line graph with only markers (no lines). Of course, you won't be able to affect the size of the points, but you will be able to show the division by colors as you are doing here.
Please refer to the linked discussion for more information.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly