BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
twillkickers
Contributor

Manually Ordering Categories in a Stacked Bar Chart

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!

question_stacked_bar.png

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Manually Ordering Categories in a Stacked Bar Chart

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
Jim
4 REPLIES 4
txnelson
Super User

Re: Manually Ordering Categories in a Stacked Bar Chart

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
Jim
twillkickers
Contributor

Re: Manually Ordering Categories in a Stacked Bar Chart

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.

0 Kudos
txnelson
Super User

Re: Manually Ordering Categories in a Stacked Bar Chart

Not that I am aware of it.

Jim
0 Kudos
Highlighted
twillkickers
Contributor

Re: Manually Ordering Categories in a Stacked Bar Chart

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!