Currency symbol position

[#1]

Hi guys,

Very quick one.

I would like my chart to show figures as £40,000, £30,000 and so on. I want the currency symbol on every value.

I have managed to get the £ sign at the top as shown in the attached file, but that is not what I want

How can I do this, as I reckon it should be very easy to do?

Thanks

[#2]

change your dimension to a calculated one and type

=money([Sale Price])

as dimension

[#3]

That puts the values on the x axis. My requirement is for the values to be on the y axis as shown in my sample file.

Extra help on this would be appreciated.

Thanks