I can't see a way to change it via formatting.



If it was me, I would convert the underlying data numbers to totaling 100 based on their shares and plot it as a regular stacked bar chart.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thanks Mr. Guessed for your response

Of course, there are Stacked columns and a 100% Stacked column
Stacked columns display actual values, which I worked on 50 samples.
on the other hand, my supervisor wants a 100% Stacked column to display data in percentage and also removing the percentage symbol from the vertical axis.


Mr. Guessed my current solution is using a text box filled with values (0 - 100), but it's not a professional way.