Adding Average of Grand Total Row to Chart

Hello,

I hope this message finds you well.

I have a data set of participants from three different locations who answer questions on a ranking scale (1 for don't agree and 5 for strongly agree, etc.).

I want to create a chart that shows a 100% stacked bar chart with the percentage of response by location as well as the singular average of that location's score.

In the attached spreadsheet for instance, I want to know the percentage of people in Adana, Ankara, and Istanbul that responded to a questions and selected 1, 2, 3, 4, 5 (using a 100% stacked bar chart).

On that same chart, I want to show the total average responses of of participants from Adana, Ankara, and Istanbul (and I want the singular number displayed on the chart).

Using column 5 (I enjoy bananas), the average response for Adana is 2.64, the average response for Ankara is 2.77, and the average response for Istanbul is 3.04. How can I get that added to a stacked 100% bar chart of the percentages of those that selected 1, 2, 3, 4, 5 (per location)?

Thanks,
Tim