Forum Discussion
Unable to change bounds and units of x axis on Excel
Hi All, I'm trying to create a line chart and I'm using dates between 1250-2020 on the horizontal axis but I'm unable to adjust the bounds and units so I can't change the intervals at which the d...
Excel does not handle dates before 1900. If you enter for example 01/01/1849 in a cell, Excel treats it as a text value, and you cannot perform date calculations with it.
It would be better to store just the year in the cells, as a number.