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

[BlueSpruce]

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

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

 

[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

 

[BlueSpruce]

No

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

 

[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

 

[JTrilloJ]

Well Colin:
I have no doubt they use the same engine.
I'm sure they do, but the starting pulley is slightly different.
Don't lose your sense of humor.
Regards

 

[isladogs]

Well Colin:
I have no doubt they use the same engine.
I'm sure they do, but the starting pulley is slightly different.
Don't lose your sense of humor.
Regards

Certainly different fuel for the same engine.
One of them may be excellent but the other is accessible

 

[BlueSpruce]

Well Colin:
I have no doubt they use the same engine.
I'm sure they do, but the starting pulley is slightly different.
Don't lose your sense of humor.
Regards

"Excel gets all the love" — Efrain Pino, mejor conocido por "BlueSpruce"

 

[Gasman]

Colin,
Any idea as to why I was unable to change the format on the secondary axis?

 

[isladogs]

Colin,
Any idea as to why I was unable to change the format on the secondary axis?

No.
I changed my chart in post #15 from Bar Stacked to Column Stacked with the same results on the secondary axis:
i.e. Standard =2 d.p. ; General Number = no decimals

 

[Gasman]

Well, whatever I select, the X axis (my secondary) does not change at all.