Order of stack in any stacked chart

Dear Experts,

I have a scenario where I need to display a chart like below:

However I am able to create this chart. Problem is with the order of colors related to different keyfigures.

I even changed the order of keyfigures in BEx query that I am consuming here but nothing got changed. I want to display keyfigure indicated by Yellow in the middle.

I browsed through SCN but no got no information related to this.. Few links are below:

Three questions regarding Chart | SCN

Please help.

Thanks and Regards,

Nitesh Kumar