You can create this effect by creating a bar chart and making separate series overlap each other. When you display only series at a time, you can format the color of that series to show you a different color. see this file.
@Debraj(ex-Roy)
Hi, buddy!
Do you happen to know who's the guy in light orange? Yes, that at the right, the one that happens to be the laziest writing...
Regards!
Dear DEBRAJ,
Thank you for your valuable reply.
What I actually mean is that the columns in the chart change colour when they get shorter or longer according to the change in values. This is for interactive charts.
Good start, Debraj,
Now, suppose the chart vertical axis is between 0 and 100. When the interactive column rises above 50 it has one colour, and when the same column changes to a value under 50 it will have another colour. Can this be done.
