A problem about Date and Time

[randomwalker]

Hi,

I came across a problem when I used Excel 2010 to graph. The data: cell A2, A3 and A4 are 2008/12/31, 2009/12/31 and 2010/12/31. cell B2, B3 and B4 are 15, 20 and 25. After I made a bar graph, the X axis shows 2008/1/1, 2009/1/1 and 2010/1/1. I don't know how 2008/12/31 changed into 2008/1/1, can anyone here help?

Thanks a lot!

2011/7/20

 

[Andrew Poulsom]

Make sure that the x axis is set to Category rather than Automatic or Date-Scale.