Chart Currency

Tieval

Still Clueless
Local time
Today, 13:18
Joined
Jun 26, 2015
Messages
475
I have a chart in a form that displays monthly figures from a query. All aspects of my database that are currency display as currency with the symbol set to £ as per my windows settings, the chart has $

Any ideas would be most helpful.
 
Assuming you are not using the 'modern' charts, click on the chart and select Edit.
Next click on the axis you want to edit and select Format Axis.
Select the Number tab, then choose Currency. Enter £ for Symbol
 
I guess I am using a modern chart then :banghead:
 
You notice I didn't give an answer for that... :D
I can't see any way of getting the symbol into a modern chart axis let alone change it
However, I rarely use a modern chart as I still prefer the older version
 
It's only for my use so I don't care too much, suspect it is a bug from our friends at Microsoft but just put it out there in case I had missed the obvious.
 
If your field is a currency datatype its just a number with a £ symbol added as formatting. So your chart axis should just be numbers with no symbol. So how did you add a symbol to it?
 
There is a setting in the chart for 'Primary Values Axis Format' which you can set to currency, this seems to achieve the $ sign rather than your universal currency setting.
 
Gotcha. No method of changing the units other than selecting Euro. That's rubbish!
I'd either use Number rather than currency or change to the older charts
 
There is a setting in the chart for 'Primary Values Axis Format' which you can set to currency, this seems to achieve the $ sign rather than your universal currency setting.
I think, I remember a bug causing this behavior, but I cannot reproduce it anymore on Access 2016 Version 1903. (File - Account - About Access).
 

Users who are viewing this thread

Back
Top Bottom