Solved How to remove decimal places from the value axis of a Modern Chart in Access?

[JTrilloJ]

I've successfully created a Modern Chart in Access.
I've set the Minimum Value to -3,000,000 and the Maximum Value to 3,000,000.Value
Axis Range >> FixedValue
Axis Format >> StandardAnd >> here's where my problem is: I'm getting two decimal places.
I don't know how to remove them.
Is it possible?
Image attached

 

[BlueSpruce]

I've successfully created a Modern Chart in Access.
I've set the Minimum Value to -3,000,000 and the Maximum Value to 3,000,000.Value
Axis Range >> FixedValue
Axis Format >> StandardAnd >> here's where my problem is: I'm getting two decimal places.
I don't know how to remove them.
Is it possible?
Image attached

You have to edit the axis scale range and number format in the chart properties.

Are these the Windows regional settings you are using?

 

[JTrilloJ]

Hi Blue:
Yes, I do have that configuration, but that's not what I want to change.
According to the image I attached, on the X-axis, where some quantities are displayed, that's where I want the quantity to be shown without the two decimal places, but I don't know how to do it.
Thanks

 

[BlueSpruce]

I want the quantity to be shown without the two decimal places, but I don't know how to do it.
Thanks

You have to edit the axis scale range and number format in the chart properties.

 

[Gasman]

Do you know how to do it on an excel chart?

 

[JTrilloJ]

Okay: It's not a big deal, but I still can't figure it out.
It's a "Modern Chart" in Access, and I don't see it in the Formatting Items.
I don't see it in the properties either.
It might not be available.
I just saw your message, Gasman. As I mentioned, it's not Excel.
Thanks again.

 

[Gasman]

No, I know it is not , but I thought the method would be the same or similar?

 

[JTrilloJ]

Thanks Gasman:
There's a substantial difference between Excel charts and Access's "Modern Charts."
Excel offers many more options.
Regards

 

[BlueSpruce]

Okay: It's not a big deal, but I still can't figure it out.
It's a "Modern Chart" in Access, and I don't see it in the Formatting Items.
I don't see it in the properties either.
It might not be available.
I just saw your message, Gasman. As I mentioned, it's not Excel.
Thanks again.

https://support.microsoft.com/en-gb...art-axes-422c97af-1483-4bad-a3db-3a9ef630b5a9

https://support.microsoft.com/en-gb/office/change-the-scale-of-the-horizontal-category-axis-in-a-chart-637897f6-0d51-4ec5-bef9-25d2c83a8450#:~:text=Click the chart.,a category axis is selected.

 

[Gasman]

Really? I cannot test as I do not have them, but a quick Google appears the same to me?

Wouldn't hurt to try?

format axis in access modern chart

However that shows that I do have them in 2019.
I can create a chart with some data, and change the format in the primary axis and see it change, but nothing happens on the secondary axis?

Perhaps Phillip will chime in as he has this video on YouTube.
I cannot remember his username here.
Edit: I *think* it is @sonic8

 

[Gasman]

What is the format of the data to that chart?
Look at that video I linked to. He points out issues with decimal and thousands characters. His format is the same as yours.

 

[JTrilloJ]

Hi again Gasman:
Looking at the chart you posted, it seems to me that the values (in this case, the vertical axis) have two decimal places.
Regarding your subsequent question, the data format in my population chart (which in my case is the horizontal axis) uses values from 0 to 3,000,000.
To create the pyramid shape, I had to use negative values for men and positive values for women.
Blue: I also looked at the link you sent me, but it's for Excel.
As I mentioned to Gasman, there are significant differences between the options in Excel and Access's "Modern Charts" feature.
Best regards to you both.

 

[Gasman]

They do, but I can get rid of them no problem. What I could not do was get the secondary axis to respect my format selections like the primary axis does.

 

[BlueSpruce]

Hi again Gasman:
Looking at the chart you posted, it seems to me that the values (in this case, the vertical axis) have two decimal places.
Regarding your subsequent question, the data format in my population chart (which in my case is the horizontal axis) uses values from 0 to 3,000,000.
To create the pyramid shape, I had to use negative values for men and positive values for women.
Blue: I also looked at the link you sent me, but it's for Excel.
As I mentioned to Gasman, there are significant differences between the options in Excel and Access's "Modern Charts" feature.
Best regards to you both.

In Ac modern charts you should be able to RightClick on your chart's axis and select format from the context menu to adjust the scaling of the decimal places.

 

[isladogs]

The previous links in post #9 were not referring to Access modern charts

It can be done either from the property sheet or in code
You used a Primary Values Axis Format = Standard which gives 2 d.p.
From the property sheet, change the Primary Values Axis Format property from Fixed to Standard Number
That will give integer values
Here's a quick example imitating what you have in post #1

You may find my 3-part series of articles on modern charts useful starting with:

Modern Chart Improvements

This article summarises the very welcome improvements to modern charts that are being rolled out in Access 365 version 2409. Changes include many new chart types and additional functionality with existing charts

www.isladogs.co.uk

The third article discusses how to use VBA code to set modern chart properties

Programming Modern Chart Properties

This article demonstrates how to modify the properties of the various modern chart types using code. VBA support was added to the Beta Channel in version 2502 build 18514.20000 released on 17 Jan 2025. It is now available in all other channels at version 2502 or later.

www.isladogs.co.uk

 

[JTrilloJ]

Just one clarification: Are you actually working with Access's "Modern Charts" or with "Classic" charts?.
The latter also offers more options.
Best regards.

 

[JTrilloJ]

Hi Colin:
I think I also mentioned that in addition to removing the decimal places, I wanted it to show the thousands separator format.
Example: 2,000,000 or -1,500,000
Thanks for your help

 

[isladogs]

If post #16 was aimed at me, I'm referring to modern charts as the links make clear

You didn't explicitly state that you wanted to show the thousands separator format.
To do so would mean using Fixed or Standard formats both of which will result in 2 d.p. being shown

You can't have comma separators without also having decimal places

 

[JTrilloJ]

Note: Commas are visible in the thousands separator of my previous post.Logically, in my case they should be periods.

 

[isladogs]

As stated you can only have a separator character if you also have 2 d.p.