topic Re: Change order of parts in a bar chart in SAS Visual Analytics

Change order of parts in a bar chart

GustavSandberg — Thu, 03 Feb 2022 11:41:34 GMT

Hello all,

my goal is to display my data in a bar chart with 2 bars.

I have the data in one category, from which I want to use 5 variables.4 of these (A, B, C, D) should be blocks in bar 1. And the 5th (X) should be bar 2.

For this I have created a custom category using these 5 variables.

In setting up the customized category I created one value group "Bar 1" where i placed the 4 variables (A, B, C, D) for Bar 1, and another value group for "Bar 2" where I placed the 5th variable (X).

When I use my custom category in a bar chart, I now have two bars. One with A, B, C, D and one with X.

My question is:

In Bar 1. Can I customize the order of which A, B, C, D are stacked in the bar?

They are now, from bottom to top, placed as A, B, C, D. I see that I can right-click the bar chart and change the order between decending and ascending. This only gives me two display-options: A, B, C, D and D, C, B, A.

What if I want to display them as B, D, A, C ?

I have tried to edit the custom category and change the order there, but nothing happens.

Re: Change order of parts in a bar chart

PeterClemmensen — Thu, 03 Feb 2022 12:01:44 GMT

Show us your code please.

Re: Change order of parts in a bar chart

PaigeMiller — Thu, 03 Feb 2022 12:01:48 GMT

How are you creating the bar charts? Show us the code (in a code box, click on the little running man icon and paste the code into the window that appears; do not provide the code as a screen capture)

Re: Change order of parts in a bar chart

GustavSandberg — Thu, 03 Feb 2022 12:25:28 GMT

I have done this is Visual Analytics using no code. Just dragged and dropped a bar chart and assigned data to it.

Re: Change order of parts in a bar chart

Madelyn_SAS — Thu, 03 Feb 2022 17:09:01 GMT

Which version are you using? And can you post an example of how your chart appears now

Re: Change order of parts in a bar chart

GustavSandberg — Fri, 04 Feb 2022 08:15:24 GMT

Hi,

Current version is SAS VA V.03.05M0P111119.

This is what the bar chart looks like. In the bar to the left, I want to place the middle block on the bottom.

(I always want the same order of the blocks, no matter the size of the blocks for the chosen period.)

Best regards,

Gustav

Re: Change order of parts in a bar chart

Madelyn_SAS — Fri, 04 Feb 2022 15:39:40 GMT

You said that you tried changing the order in your custom category. Have you tired creating a custom sort?

Re: Change order of parts in a bar chart

GustavSandberg — Fri, 04 Feb 2022 16:23:00 GMT

hi,

yes, I have tried changing order in my custom category.

Trying to create a custom sort on my custom category only allows me to change order of the value groups, but not the variables inside the value groups.

However, a colleague of mine did solve it earlier today by doing a custom sort on the original category, on which the custom cateogry was based.

Best regards,

Gustav