Category
Chart Builder
Product Version
9.0
Sorting a Vertical Stacked Column chart and Legend
Answered
Hello,
I would like to re-order the data and legend in a stacked column chart. My table looks like the following. What I'm trying to do is order the stacked chart to be in the data order descending.
However, when I go to my chart it's being put into alphabetical order based on the cause_name.
I have these options enabled:
What I want to see is the Transfer Syntax Error at the top of the first bar, followed by Requested Service Option Not Subscribed, and so on. What am I doing wrong?
The same question
Hi Ryan,
Thanks for contacting Yellowfin with your question!
What you want to do is use Reference Code sorting, so that the sort order is defined in the code and then applied to the field. You can do that in the column formatting field in the Data tab of the Report Builder. For example, here Demographic is the stand in for your 'cause_name' field:
When you're setting it up for the first time you'll need to define the code by clicking Create New. You can then create the order and add specific colours if you wish:
And then choose to use reference code sorting on the chart:
I hope that helps!
Kind regards,
Chris
Hi Ryan,
Thanks for contacting Yellowfin with your question!
What you want to do is use Reference Code sorting, so that the sort order is defined in the code and then applied to the field. You can do that in the column formatting field in the Data tab of the Report Builder. For example, here Demographic is the stand in for your 'cause_name' field:
When you're setting it up for the first time you'll need to define the code by clicking Create New. You can then create the order and add specific colours if you wish:
And then choose to use reference code sorting on the chart:
I hope that helps!
Kind regards,
Chris
Thanks Chris. We will try it out.
Ryan
Thanks Chris. We will try it out.
Ryan
No worries, let me know how it goes!
Kind regards,
Chris
No worries, let me know how it goes!
Kind regards,
Chris
Hi Chris, you can close this ticket. Thanks!
Hi Chris, you can close this ticket. Thanks!
That's great to hear! Have an excellent weekend!
That's great to hear! Have an excellent weekend!
Replies have been locked on this page!