I must not be searching on the right text as I figure this question had to have been asked and answered, but I cannot find it. I am creating a bar chart where the x-axis is the month names. I want it to be a rolling 12 months so right now would start with Nov and end with Oct. I could provide the order 0-11 in my data and match it to the right label. So in the case mentioned my data would have 0=Nov, 1=Dec…11=Oct. But When I select to sort ascending, it sorts the month names which is undesirable. Unsorted does not give the desired order either. I appreciate any direction.
Answering my own question, I have sorted my data source and then used unsorted for the graph. I’m not confident this will always work, but we’ll see.
1 Like