Forum Discussion

Copper Contributor

Jun 01, 2023

Solved

Horizontal Axis Labels - impossible to change date

I have to fill in a weekly spreadsheet for my boss, that she has created. She has created a chart to go with this, that usually works OK when I update it, but it has recently gone haywire. (I am no...

Charting

excel

Excel on Mac

Riny_van_Eekelen
Jun 02, 2023
Jaycey Check Excel, Preferences... Then 'Calculation' in the Formulas and Lists group.

I suspect that you accidentally switched on the 'Use 1904 date system' for the workbook. Uncheck that option and all should return to normal.

Riny_van_Eekelen

Platinum Contributor

Jun 02, 2023

Jaycey Check Excel, Preferences... Then 'Calculation' in the Formulas and Lists group.

I suspect that you accidentally switched on the 'Use 1904 date system' for the workbook. Uncheck that option and all should return to normal.

Jaycey
Copper Contributor
Jun 02, 2023
Riny_van_Eekelen Thank you SO much for this - you've saved my life! It's something I've not spotted before, but now I've turned it off, I can edit the labels just fine?

For some reason, the dates in the spreadsheet all lost a few years, but I corrected that, and then everything came right. (I've always had an issue with bringing dates over from the CSV file I'm given - all American dates which I have to hand-correct, but there you are, one of the crosses I have to bear as there's no other way of doing it...😉)

Thank you so much again! 👍🏼