Unable to change bounds and units of x axis on Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2535320%22%20slang%3D%22en-US%22%3EUnable%20to%20change%20bounds%20and%20units%20of%20x%20axis%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535320%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20All%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI'm%20trying%20to%20create%20a%20line%20chart%20and%20I'm%20using%20dates%20between%201250-2020%20on%20the%20horizontal%20axis%20but%20I'm%20unable%20to%20adjust%20the%20bounds%20and%20units%20so%20I%20can't%20change%20the%20intervals%20at%20which%20the%20dates%20appear%20on%20the%20chart.%20I%20want%20the%20dates%20to%20be%20written%20on%20the%20chart%20in%20150%20year%20intervals.%20I%20have%20tried%20writing%20the%20years%20in%20the%20dd%2Fmm%2Fyyyy%20format%20but%20this%20has%20not%20worked.%20I've%20also%20tried%20changing%20the%20'number%20value'%20from%20general%20to%20date%20and%20this%20has%20not%20worked.%20When%20I%20try%20to%20do%20these%20fixes%2C%20it%20recognises%20my%20date%20range%20as%20between%201903-1905.%20I%20would%20appreciate%20some%20help%20in%20overcoming%20this%20issue.%20Thank%20you%20in%20advance.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2535320%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2535339%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20change%20bounds%20and%20units%20of%20x%20axis%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1100387%22%20target%3D%22_blank%22%3E%40HamadHussain10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20does%20not%20handle%20dates%20before%201900.%20If%20you%20enter%20for%20example%2001%2F01%2F1849%20in%20a%20cell%2C%20Excel%20treats%20it%20as%20a%20text%20value%2C%20and%20you%20cannot%20perform%20date%20calculations%20with%20it.%3C%2FP%3E%0A%3CP%3EIt%20would%20be%20better%20to%20store%20just%20the%20year%20in%20the%20cells%2C%20as%20a%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

1 Reply

@HamadHussain10 

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.