You have to use date functions to convert the text dates to real dates. Dates stored as text-If dates are stored as text dates instead of real dates, a date-based axis will never work.The following are some of the problems you might encounter: As appropriate, choose either Text Axis or Date Axis from the Axis Type section (see Figure 3.7).Ī number of complications that require special handling can occur with date fields.In the Format Axis task pane that appears, select the Axis Options at the top, then the chart icon, and then expand the Axis Options category.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.
