I would like the column chart to show the percent as the value label.

For example

East 2
West 4
North 10
South 4

In the chart, I want the y-scale to be 0 to 10 (or 12), but the values on
the data labels to be:
East 10%
West 20%
North 50%
South 20%

I have tried putting the % in a separate column but of course that shows up
as a different series.

Seems like it should be so simple, but I can't get it to do it. What am I
missing, please.

tia for any suggestions