Conditional formatting of chart axes
To change format of the label in the chart axis, do the following:
1. Right-click in the axis and choose Format Axis... in the popup menu:
2. In the Format Axis dialog box, on the Number tab, select Custom category and then change the field Type and click the OK button:
- If you need a unique representation for positive, negative, and zero values, just write multiple formats, separating each with a semicolon.
- If you write two formats, the first applies to positive and zero values and the second applies to negative values.
- If you write three formats, the first applies to positive values, the second to negative values, and the third to zero.
- If you write four formats, they apply to positive, negative, zero, and text values, respectively.
[Blue]# ###;[Red]# ###;[Green]~0;
- If you want to create a custom condition based on values below or equal to some point (for example, -60) and greater than it, you could type the following condition codes: