ExcelBanter - Custom number in Axis

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Custom number in Axis (https://www.excelbanter.com/charts-charting-excel/222743-custom-number-axis.html)

Shevvie

Custom number in Axis

I need to display percentage numbers in a vertical axis showing the % sign
beside the maximum number only. How do I edit this?
50%
40
30
20
etc
Thanks

Bernard Liengme[_3_]

Custom number in Axis

Make a text box with 50% and carefully align that over the actual axis label
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shevvie" wrote in message
...
I need to display percentage numbers in a vertical axis showing the % sign
beside the maximum number only. How do I edit this?
50%
40
30
20
etc
Thanks

All times are GMT +1. The time now is 12:22 AM.