Laying Out and Formatting a Chart : Formatting axis titles, markers, lines, and labels : Defining the axis data type and number format : How to set the data type and format of an axis
 
How to set the data type and format of an axis
1 In Format Chart, navigate to the axis section.
2 In Type, select a data type from the list, as shown in Figure 17‑90.
Figure 17‑90 X-Axis section of Format Chart
3 Choose Format Editor.
The Edit Format dialog box displays options for the data type of the axis. Figure 17‑91 shows options for the Date/Time data type.
Figure 17‑91 Editing the format of a date