topic Re: Manually Ordering Categories in a Stacked Bar Chart in Discussions

Manually Ordering Categories in a Stacked Bar Chart

twillkickers — Tue, 22 May 2018 13:10:59 GMT

See question in attached photo. I currently have a stacked bar chart, but I would like to be able to order the categories differently in all the bars. Is there a way to do this in the GUI graph builder or in JSL? Thanks for your help!

Re: Manually Ordering Categories in a Stacked Bar Chart

txnelson — Mon, 21 May 2018 22:25:19 GMT

You can use the column properties of Value Ordering and Value Colors to change the order and colors. Right click on the header for the column in question and select Column Ordering. A dialog box will open and you will be able to set the order to use. Do the same with Value Colors to change the colors.
Also, you should be able to change the colors just by clicking on the values in the legend

Re: Manually Ordering Categories in a Stacked Bar Chart

twillkickers — Tue, 22 May 2018 14:22:23 GMT

Is there a way to change the order of the categories within the bars in the graph builder itself without using column ordering? I was able to change the order of the categories in the legend by using graph builder.

Re: Manually Ordering Categories in a Stacked Bar Chart

txnelson — Tue, 22 May 2018 15:53:12 GMT

Not that I am aware of it.

Re: Manually Ordering Categories in a Stacked Bar Chart

twillkickers — Tue, 22 May 2018 21:05:14 GMT

I ended up using the JSL command

DataColumn << Set Property("Value Ordering", {"X", "Y", "Z"})

to order the values the way I wanted before producing the graph, as you suggested. Thanks for your help!