Bar Colors

Iron Contributor

Dear Experts,

                   Greetings!

May be a stupid question, but will ask.

How to Color a bar differently based on the different values it has(in X-axis) or say in Y-axis,

for example in current case, I want all the Bars for PCSI with different colors , with those of the ACSI

anupambit1797_0-1695102162642.png

 

But the problem is when I select any of the bar it highlight the whole chart and bars..

Thanks in Advance,

Br,

Anupam

             

1 Reply

@anupambit1797 You would have to work with separate series for ASCI and PSCI and have the bars overlap as in the attached (smaller scale) example. Each series will have a value or NA# (or an empty string if you prefer that ) for all data points. In the example I used the NA and ISNA functions.

 

Screenshot 2023-09-19 at 08.36.03.png

See if you can get this work on your real data.