Help with custom format in Primary Value Axis (1 Viewer)

iCyrius

New member
Local time
Today, 10:43
Joined
Apr 5, 2016
Messages
18
Good morning,

I want to display my primary axis (Y-axis) values as xxxk (2k for example). But the chart's Property Sheet drop down menu does not allow custom formatting. It only limits choices to a handful of Access formats.

Is there a way to insert custom formatting numbers in Access charts?

Thanks
 

Ranman256

Well-known member
Local time
Today, 13:43
Joined
Apr 9, 2015
Messages
4,120
put the format in the query.
then the chart will use it.
 

oleronesoftwares

Passionate Learner
Local time
Today, 10:43
Joined
Sep 22, 2014
Messages
1,140
Hi,
Can you double click the chart in design view, if so what happens?

In my version of ms access, i am able to access the feature when i double click a chart in design view, see the attached image.
chart formating.PNG
 

iCyrius

New member
Local time
Today, 10:43
Joined
Apr 5, 2016
Messages
18
Hello. Thanks for your help, but my version is different. It might be 2016 or 365, not sure and do not know how to check it.
 

iCyrius

New member
Local time
Today, 10:43
Joined
Apr 5, 2016
Messages
18
Yes. Double clicking only opens a property sheet. The menu that you shared is not available in my version.
 

Users who are viewing this thread

Top Bottom