Chart on powerpoint slide - formatting changes after data is filled in.

On the attached image one sees that the top left chart has a 'standard' number format for the axis wheras the bottom right has a 'scientific' format.
Initially both charts had the 'standard' number format for the labels.  After filling the dataset for the chart with VBA code running in Microsoft Access (no changes to formatting, only the numbers to be displayed) the one chart is OK but the other has been changed to 'scientific' format which is unwanted.

Why is this happening?
More important - how can I set the axis tick lables formatting back to 'standard' via VBA code?
LVL 46
AndyAinscowFreelance programmer / ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
No File
0
Rgonzo1971Commented:
HI,

Maybe

    ActiveChart.Axes(xlCategory).TickLabels.NumberFormat = "0"
    ActiveChart.Axes(xlValue).TickLabels.NumberFormat = "0"

Regards
0
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
Aaagh, here is the image.

SNAG-0000.bmp
Thanks.  That just displays without any decimal point.
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

Rgonzo1971Commented:
ActiveChart.Axes(xlCategory).TickLabels.NumberFormat = "0.0"
ActiveChart.Axes(xlValue).TickLabels.NumberFormat = "0.0"
0
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
Getting closer.
The 0.0 isn't suitable as some axes then just show each tick label as zero however .NumberFormat = "0.####" is rather closer.
SNAG-0001.bmpHowever that now leaves an ugly '.' when the labels are all integer - see the 'BUT' graphs
0
Rgonzo1971Commented:
then try this format

"[>=1]0;[=0]0;0.######"

Regards
0
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
That cures that but then promptly brings another:
SNAG-0002.bmpWhere the axis now has two lables both of 2 with the custom format
SNAG-0003.bmp

What I want (which is how the empty chart is formatted) results in
SNAG-0004.bmpusing the 'standard' setting for the label format
SNAG-0005.bmp

For some reason this setting is being replaced on some, but not all, charts after I fill the values into the dataset.
0
Rgonzo1971Commented:
then try

ActiveChart.Axes(xlCategory).TickLabels.NumberFormat = "General"
 ActiveChart.Axes(xlValue).TickLabels.NumberFormat = "General"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
I'd tried 'Standard' before asking the question - it barfed.  Now with 'General' it works perfectly.
Thanks.
0
Rgonzo1971Commented:
General in English

ActiveChart.Axes(xlCategory).TickLabels.NumberFormatLocal = "Standard"
0
AndyAinscowFreelance programmer / ConsultantAuthor Commented:
Unfortunately Standard is also an English word with an similar meaning in this context.  Anyway it works now.  :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft PowerPoint

From novice to tech pro — start learning today.