In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis value is text-type date series, eg 20010101, 20010102, 20010103.

Instead of showing this X axis value like "20010101", "20010102", it shows only the sequence of the X axis data- Point "1", Point "2", Point "3", and so on. When I check the source data, it shows correct X axis value in 'Horizontal Axis Labels'.

Charts in Excel 2003 didn't have this kind of issue. How can I solve this problem to show the proper X axis value?