• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic color bar chart


New Member
Hi all,
I have a chart with different colors and descending order. (Asia = Yellow, Australia = Orange, America = Gray ...).
For example if Asia become 4th rank, the color bar for Asia is still Yellow, not become Blue. And I want the chart still in descending order.
How to make it in dynamic, not manually. Thanks before.



Excel Ninja
Send a sample Excel-file which has Your chart with needed data; pictures are challenge to test.
Have You used fixed colors ... or automatic?


New Member
Thank you very much Vietm, the key point is we have to re-rank our data when its' changes, and the chart will be shown in the right order (of course after we have made the rule for the colors).