Skip to main content
jahnavi
Contributor ⭐️⭐️⭐️⭐️⭐️
November 9, 2017
Question

How to change the column orders in a column chart report?

I have a report with four stages A, B, C and D and count of customers in a column chart. I can sort on the count ascending or descending. If i would like the report to show coulmns in order B A D C. is is possible?

5 replies

leanne
Contributor ⭐️⭐️⭐️⭐️⭐️
November 9, 2017
We'd love to have this too!

Column charts always sort in alphabetical order. So we've worked around this by changing the names of the fields in some cases (ie. if you really want Boy, Apple, Dog, Cat, you rename the fields a.Boy, b.Apple, c.Dog, d.Cat.)  This works for some things, but not if you can't rename the stages you're using.  Possibly could create a lookup field that you can rename. 

To make things more interesting, stacked column charts always sort labels in reverse alphabetical order for some reason, so if you're using a stacked column chart, you'd have to reverse that. 
Translate
jahnavi
jahnaviAuthor
Contributor ⭐️⭐️⭐️⭐️⭐️
November 28, 2017
Thanks Leanne. Works now. but sorting flexibility would be much better.
Translate
leanne
Contributor ⭐️⭐️⭐️⭐️⭐️
November 28, 2017
100% agree!
Translate
venky_reddy_k
Helper ⭐️
March 9, 2018
Changing the column order in a column chart is not possible by dragging the columns to the desired order,  though the workaround mentioned above is one way to actually achieve it.

Thanks
Venky
Translate
sai_ram
Expert ⭐️⭐️
March 9, 2018
@Leanne, Thanks for the workaround provided here
Translate