I created an XY scattered chart with dates/months as X values. my data set starts from Sep11 but on the chart it goes back to Jan-00. I know that it might be linked to formatting of the cells so I have checked it and seems to be ok. I also know that I can manage it by setting scales to non-auto but I need it to be auto.