Changing the Format and Precision of Graph and Chart Axes

Change the format of an axis to display a different numeric or time format on the axis of a graph or chart. Change the precision to specify the number of digits the axis displays.

Complete the following steps to change the format and precision of a graph or chart axis.

1. Right-click the graph or chart and select Properties, 3D Plot Properties, or 3D Graph Properties.
2. Select the Display Format or Format tab.
3. Select the axis you want to configure.
4. Select a format from Type. If the representation of the numbers on the scale is floating-point, you cannot display the numbers on the axis as hexadecimal, octal, or binary.
5. Use Digits and Precision Type to change the precision of the numbers on the axis.

Note  Select Advanced editing mode to enter format strings and customize the precision of numbers on the axes.

6. Click OK.