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

 

[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

 

[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

 

[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.

 

[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.

 

[JTrilloJ]

Colin: Post #16 wasn't for you.
I've seen your articles a while ago and downloaded the examples, which have served as a guide for me on several occasions.
As I mentioned before, this isn't very important.
It's just to make the reading more "intuitive."
In short, I was looking for: Decimals >> NO, thousands separator >> YES.
Since that doesn't seem to be possible, we'll leave it as is.
Thanks.

 

[isladogs]

Can the OP specify custom literal values by entering them manually?

No

 

[Gasman]

I have always preferred to do charting in Excel because it has more variety and richer functionality.

I do the same, but never knew I had Modern Charts.
So I have learnt something from this post.

 

[isladogs]

I have always preferred to do charting in Excel because it has more variety and richer functionality. Excel gets a lot of love, Access doesn't

Whilst that was true in the case of 'classic charts', modern charts in Access now have similar functionality to those in Excel.
In fact both use the same Ivy charting engine and in A365 have almost identical chart types
The modern chart types in A2019 are much more limited