Please help me in preparing the stacked chart as in the image below
@EuroSree Try the attached.
First suggestion would be to transform the data to look as follows:
Once you transform your data, review the following Clustered Stacked Bar Chart video on YouTube. Review also the attached workbook. Please let me know if you have any further questions.