Defining the axis data type and number format
The axis data type and format determine how the chart builder arranges the data that appears on an axis. An axis has one of the following data types:
*Linear
This axis type spaces values evenly.
*Logarithmic
This axis type spaces values based on the ratio of their values. For example, values 1 and 10 are the same distance apart as 10 and 100.
*DateTime
This axis type shows data on a date or time scale.
*Text
This axis type displays text only and spaces words evenly. The location of a data point on a text axis does not indicate its size. Typically, a text axis is a category 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 22‑90.
Figure 16-9 X-axis section of Format ChartFigure 16-9 X-axis section of Format Chart
Figure 22‑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 22‑91 shows options for the Date/Time data type.
Figure 16-10 Editing the format of a dateFigure 16-10 Editing the format of a date
Figure 22‑91 Editing the format of a date