Forum Discussion
Bar Colors
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.
