Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-17-2019, 05:29 AM   #1
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Chart Currency

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.

Tieval is offline   Reply With Quote
Old 04-17-2019, 05:41 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,247
Thanks: 115
Thanked 3,075 Times in 2,793 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Chart Currency

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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 04-17-2019, 05:51 AM   #3
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Re: Chart Currency

I guess I am using a modern chart then

Tieval is offline   Reply With Quote
Old 04-17-2019, 05:54 AM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,247
Thanks: 115
Thanked 3,075 Times in 2,793 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Chart Currency

You notice I didn't give an answer for that...
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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Tieval (04-17-2019)
Old 04-17-2019, 06:02 AM   #5
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Re: Chart Currency

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.
Tieval is offline   Reply With Quote
Old 04-17-2019, 06:44 AM   #6
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,247
Thanks: 115
Thanked 3,075 Times in 2,793 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Chart Currency

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?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 04-17-2019, 06:59 AM   #7
Tieval
Still Clueless
 
Join Date: Jun 2015
Location: UK
Posts: 429
Thanks: 57
Thanked 42 Times in 42 Posts
Tieval is on a distinguished road
Re: Chart Currency

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.

Tieval is offline   Reply With Quote
Old 04-17-2019, 07:10 AM   #8
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,247
Thanks: 115
Thanked 3,075 Times in 2,793 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Chart Currency

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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 04-17-2019, 08:48 AM   #9
sonic8
AWF VIP
 
Join Date: Oct 2015
Posts: 273
Thanks: 45
Thanked 77 Times in 74 Posts
sonic8 is on a distinguished road
Re: Chart Currency

Quote:
Originally Posted by Tieval View Post
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).

__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency -> Currency Pair xspdr Tables 5 09-23-2014 10:22 PM
Excel Chart - Macro to globally change multiple chart titles? parodytx Excel 1 04-30-2011 06:54 AM
Convert Currency to another currency amount AlaaB Modules & VBA 9 08-18-2010 11:35 PM
Convert Currency to another currency amount AlaaB Queries 1 08-15-2010 07:28 AM
Display currency value in a string but retain the currency format s_m_chamberlain Reports 1 08-22-2006 02:20 AM




All times are GMT -8. The time now is 01:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World