Skip to main content
Question

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

  • November 9, 2017
  • 5 replies
  • 82 views

jahnavi
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
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
Forum|alt.badge.img+1
  • 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
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • November 28, 2017
Thanks Leanne. Works now. but sorting flexibility would be much better.

leanne
Forum|alt.badge.img+1
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • November 28, 2017
100% agree!

venky_reddy_k
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
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • March 9, 2018
@Leanne, Thanks for the workaround provided here