You have to use date functions to convert the text dates to real dates. The following are some of the problems you might encounter:
Right-click the horizontal axis and select Format Axis.To explicitly choose an axis type, follow these steps: You can explicitly choose an axis type rather than letting Excel choose the default.