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

  • 4
  • Problem
  • Updated 6 months ago
  • Acknowledged
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?
Photo of Jahnavi

Jahnavi, Champion

  • 2,392 Points 2k badge 2x thumb

Posted 10 months ago

  • 4
Photo of Leanne

Leanne, Champion

  • 4,696 Points 4k badge 2x thumb
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. 
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,334 Points 10k badge 2x thumb
@Leanne, Thanks for the workaround provided here
Photo of Jahnavi

Jahnavi, Champion

  • 2,392 Points 2k badge 2x thumb
Thanks Leanne. Works now. but sorting flexibility would be much better.
Photo of Leanne

Leanne, Champion

  • 4,686 Points 4k badge 2x thumb
100% agree!
Photo of Venkateswara Reddy Kasireddy

Venkateswara Reddy Kasireddy, Official Rep

  • 2,444 Points 2k badge 2x thumb
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