Forum Discussion

pmr2000

Frequent Visitor

7 years ago

undefined

I have a column with rows Jan, Feb, Mar, etc. When I visualize in line and stacked column it is sorting Dec, Nov, etc from left. This must be a simple one! Not sure why it is sorting Dec-Jan in...

Need Help

Aron_Moore

Solution Specialist

7 years ago

Have you tired ascending/descending on all your fields?

Check this link

pmr2000

Frequent Visitor

7 years ago

Thanks that helped I sorted the chart area by ascending it put the stacked column (Mar-Dec) in correct order left to right.

However it left the unstacked column months of Jan-Feb in reverse order.

Link states may need to manipulate the source data.

I have the months as text not values, would it be better to change the text to date format or key off another column like Jan=1, Feb=2, etc?