Manually Ordering Categories in a Stacked Bar Chart

[#1]

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!

[#2 · Accepted solution]

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

[#3]

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.

[#4]

Not that I am aware of it.

[#5]

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!