Help with custom format in Primary Value Axis

[iCyrius]

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]

put the format in the query.
then the chart will use it.

 

[oleronesoftwares]

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.

 

[iCyrius]

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]

put the format in the query.
then the chart will use it.

I will give it a try. Thanks

 

[oleronesoftwares]

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.

Have you tried double clicking to see the effect?

 

[iCyrius]

Yes. Double clicking only opens a property sheet. The menu that you shared is not available in my version.