Problem with dates in Excel after switching version

[Mirinquads]

Greetings all.
I have switched from Excel version 365 to Office 2021, my charts have had trouble being displayed properly, if they involve dates.

Graph.png

As seen in the screenshot here, it seems It's displaying dates from 1/0 and 30/12 - It seems to be a problem that people have had before, but I have had a hard time pinpointing exactly what to do.

The formatting on the dates is Custom at the moment as dd/mm/yy - day.

Graph1.png

I have tried changing them in here, but to no effect so far.

I hope you can help me!

Thanks in advance

[6StringJazzer]

We can't do much with a picture. Please attach the file so we can see the data. See yellow banner at the top of the page.

A change in version should not have any effect on the chart. I am guessing something else has also changed.

By the way, why would you change from Excel 365 to Office 2021? That is a downgrade.

[MrShorty]

Difficult to debug a picture, an actual sample file uploaded to the forum would better allow us to help you.

Debugging steps I usually start with:
1) Dates stored as text? (I usually test with an ISTEXT() function)
2) There appears to be a 0 value (or something Excel is interpreting as 0) somewhere in the dates. Can you find it?

Do either of those reveal a problem?

[Mirinquads]

It's due to work that Im switching. The extra features are unneeded for me at the moment, so to save money i switched.

The appropiate file is uploaded, and the tab to look in is called "Weigh-ins"

Thanks for the help

[romperstomper]

You've got a #REF error on your calculations sheet that is messing up the data, and your axis actually has its number format set to m/d so you need to change that to dd/mm/yy

[Mirinquads]

You've got a #REF error on your calculations sheet that is messing up the data, and your axis actually has its number format set to m/d so you need to change that to dd/mm/yy

Thanks Rory!

Attachment 774712

Like I said, im really new at this, so please excuse my ignorance! I have changed the formatting here, but it seems to not do anything, is it the wrong place? Also I i seem to be unable to locate the REF error - could you be so kind to point me to it?

Once again, please excuse my ignorance, I have googled around quite a bit, but seem to still be unable to slow the issues.

[Mirinquads]

Difficult to debug a picture, an actual sample file uploaded to the forum would better allow us to help you.

Debugging steps I usually start with:
1) Dates stored as text? (I usually test with an ISTEXT() function)
2) There appears to be a 0 value (or something Excel is interpreting as 0) somewhere in the dates. Can you find it?

Do either of those reveal a problem?

I uploaded a picture, but I will keep checking through the data

[romperstomper]

It was in B68 or 69 on the calculations sheet. I have made the changes on this verison.

[Mirinquads]

It was in B68 or 69 on the calculations sheet. I have made the changes on this verison.

Aaah finally i get it, thanks!

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.