Help

Chart displaying order incorrectly, or at least not the way I'd expect

Topic Labels: Base design
Solved
Jump to Solution
68 2
cancel
Showing results for 
Search instead for 
Did you mean: 

image
Greetings!
I’d created a formula:
CONCATENATE({Month #},“-”,Month)
so that grouping in my table(s) would do so since obviously April would be first in the order, etc. However, when I have it sorted in the chart, as you see, the order is, well, not what I’d expect.
Any suggestions?

1 Solution

Accepted Solutions

It’s alphabetizing those segments, so you would need to put a leading zero before the Month #.

So, for the Month portion of your formula, change it to this:

RIGHT("0" & {Month #},2)

See Solution in Thread

2 Replies 2

It’s alphabetizing those segments, so you would need to put a leading zero before the Month #.

So, for the Month portion of your formula, change it to this:

RIGHT("0" & {Month #},2)

OMG, thank you. DOH! Appreciate the insight.

Labels