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
But the problem is when I select any of the bar it highlight the whole chart and bars..
Thanks in Advance,
Br,
Anupam
@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.
See if you can get this work on your real data.