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?
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.
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.
100% agree!
Thanks Leanne. Works now. but sorting flexibility would be much better.
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
Thanks
Venky
Userlevel 7
+1
@Leanne, Thanks for the workaround provided here
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.