VBA: Autochange the Number Format on an Excel Chart Axis

[MrMaker]

Hello all,

I have a chart in Excel that changes as the selected source data changes (this is done with some simple VBA).

The problem is that the source data could be number/currency/percentage dependant on what is selected.

Is there any VBA available to auto update the number format on the axis as and when the source data is changed (ideally something like: if Cell B5 on Sheet1 says 'Percentage' format Chart 1 axis to %, if Cell B5 on Sheet 1 says 'Currency' format Chart 1 axis to £ .....etc)

Thanks in advance

 

[MrMaker]

Anyone?