Forum Discussion

pmr2000's avatar
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's avatar
Aron_Moore
Solution Specialist
7 years ago

Have you tired ascending/descending on all your fields?

 

Check this link

  • pmr2000's avatar
    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?