topic Re: How do I create a bar chart with different color bars using VA? in SAS Visual Analytics

How do I create a bar chart with different color bars using VA?

CousinIt — Wed, 19 Oct 2022 12:48:07 GMT

Hello! In VA, how do I create a bar chart with each bar having a different color? In the picture, the x-axis range from "11" (bad) to "1" (good).... and I'd like to add a color gradation dimension to my visualization.... say make "11" red and slowly change the bars in color to a green "1". Is this possible in VA? Thanks in advance for everyone's reply!! I'm hoping someone has done this before and will be able to assist me. Thank you in advance for your assistance!

Re: How do I create a bar chart with different color bars using VA?

Madelyn_SAS — Wed, 19 Oct 2022 13:05:49 GMT

You should be able to do this with display rules.

Working with Display Rules

Re: How do I create a bar chart with different color bars using VA?

Sam_SAS — Wed, 19 Oct 2022 13:20:31 GMT

Hello,

You can make a bar chart with a Color role by using SAS Graph Builder (select Build Custom Graphs from the top left menu). Then, you can import the custom graph into your report:

If you want the same measure to be used for both the bar height and the bar color, you can change those roles to a single shared role in Graph Builder.

I don't think you can easily change the gradient fill colors for a bar chart, however. You can set the gradient colors by making a custom theme, but I think this would apply to every object in your report? I don't have much experience with this and I might be wrong.

A different approach would be to make a series of display rules to color the bars, but you would have to hard-code the interval values.

Let us know if that helps,

Sam

Re: How do I create a bar chart with different color bars using VA?

CousinIt — Wed, 19 Oct 2022 13:22:07 GMT

Thank you very much!!

Re: How do I create a bar chart with different color bars using VA?

CousinIt — Wed, 19 Oct 2022 20:01:13 GMT

Thank you very much!!

Re: How do I create a bar chart with different color bars using VA?

Teo_ita — Thu, 29 Dec 2022 10:16:09 GMT

Hi Sam!

could you kindly pass me some examples about this?
In particular, I can't insert different colors for the bar graph with the trend:

is it possible to do it like this?

thx a lot!

Re: How do I create a bar chart with different color bars using VA?

Sam_SAS — Thu, 29 Dec 2022 22:01:03 GMT

Hello @Teo_ita,

If I understand correctly, it looks like you want to create a color-mapped display rule for a bar-line chart, using the category that is assigned to the Lattice Columns role (Priorita in your example below.) Is that right?

You can create such a display rule for a regular bar chart, but it looks like this is not supported for a bar-line chart (or a custom graph with those elements). I will investigate to see whether the documentation for display rules should be updated.

Thanks,

Sam

Re: How do I create a bar chart with different color bars using VA?

Teo_ita — Fri, 30 Dec 2022 08:38:41 GMT

Yeah, yeah, that's right... You understand very well

I can't do it: it doesn't give me the possibility to create Rules on the
Category, but only on the Measures, why?
[image: image.png]
only this one:
[image: image.png]
Is there any configuration and/or variable assignment problem?
How do you create a Display Rule for a Category data item?

Re: How do I create a bar chart with different color bars using VA?

Sam_SAS — Fri, 30 Dec 2022 22:06:07 GMT

I think it is just a limitation of the software. I am not a developer but I seem to understand there are difficulties applying display rules for a category when there are multiple response (measure) variables.

The documentation says:

Color-mapped display rules are not applied if there are two measures assigned to the same axis.

I suspect that this is the same limitation you are seeing for bar-line charts and the doc should be phrased differently. I will look into that.

You can create a feature request here:

https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas/label-name/sas%20visual%20analytics

It is possible that a request already exists for this. All feature requests are reviewed by the product management team.

Thanks,

Sam

Re: How do I create a bar chart with different color bars using VA?

BrunoMueller — Tue, 03 Jan 2023 14:13:22 GMT

It is possible when you use "Build Custom Graph"

Here are the steps I used:

create a new empty custom graph
add a bar chart
add a line chart
add a new data lattice role
In the options for "A1", the first cell, change the setting for
In the options for the line chart, change the color for the line
In the options for the bar chart, switch on data labels
save the custom graph template
import it in the objects pane
now you can assign display rules

Give it a try.

Re: How do I create a bar chart with different color bars using VA?

Sam_SAS — Tue, 03 Jan 2023 14:46:09 GMT

@BrunoMueller I was able to get your version working in Viya 4. When I tried it before, it didn't work. I guess that the options you specified in the custom graph are critical for the display rules to work.

@Teo_ita , let us know if you are able to get this working.

Thanks,

Sam

Re: How do I create a bar chart with different color bars using VA?

Teo_ita — Tue, 03 Jan 2023 16:14:23 GMT

Hi Bruno, thx!

but I can't do what you tell me...

I have Viya 3.4 and I don't have '...the options for the line chart, change the color for the line'

but I solved it by using Display Rules and creating a Numeric variable from my Category variable...
A thousand thanks!