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

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

  • November 9, 2017
  • 5 replies
  • 120 views
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. 
jahnavi
jahnaviAuthor
Contributor ⭐️⭐️⭐️⭐️⭐️
November 28, 2017
Thanks Leanne. Works now. but sorting flexibility would be much better.
leanne
Contributor ⭐️⭐️⭐️⭐️⭐️
November 28, 2017
100% agree!
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
sai_ram
Expert ⭐️⭐️
March 9, 2018
@Leanne, Thanks for the workaround provided here