Jul 10 2021 02:30 PM
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 dates appear on the chart. I want the dates to be written on the chart in 150 year intervals. I have tried writing the years in the dd/mm/yyyy format but this has not worked. I've also tried changing the 'number value' from general to date and this has not worked. When I try to do these fixes, it recognises my date range as between 1903-1905. I would appreciate some help in overcoming this issue. Thank you in advance.
Jul 10 2021 02:38 PM
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.