Coloring on a bar graph

[andyjohnston]

I created a column chart with multiple columns. I was coloring them using the conditional coloring based on what value they were in the chart. But, I ran into a problem where when two columns have the same value they will always be the same color. I want them both to be different colors. Is there a different way to approach this? 

[DRay]

Hi @andyjohnston.

Are you using a Widget Script to do the formatting? I don't know of a way to use conditional formatting AND have columns with the same value have different colors. You might need to use a different visualization type, or split the data differently, or add another value that affects the coloring.

[Helena_qbeeq]

Hi @andyjohnston ,

If the objective is to have different colors for each bar, have you tried a script similar to this one?

This might be a solution.

Please let me know if this works for you : )

Always here to help,
Helena from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

[DRay]

Hello @andyjohnston ,

I wanted to follow up to see if the solution offered by @Helena_qbeeq worked for you.

If so, please click the 'Accept as Solution' button on their post, that way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.