|
Specifying Chart Value Formats |
|
In Predictive Systems Lab, the formatting of axis labels and series marks is accomplished through the use of a sequence of characters that can specify, among other properties, a number of significant digits, leading and trailing zeros, negative value notation, exponential notation, or just simply meaningful text.
In numerical formats, a sequence of up to three character strings can be used. The first character string is responsible for formatting positive numbers, or all numbers if the remaining strings are not indicated. The second character string is responsible for formatting negative numbers, and finally, the third string is responsible for formatting zero values.
Characters That can be Used to Specify Format
Expression |
Character Name |
Meaning |
Comments |
||
# |
Number Sign |
Placeholder for significant digits. |
Can be used anywhere in a string except after the exponential sign.
|
||
0 |
Zero |
Placeholder for significant digits and leading or trailing zeros.
|
|
||
E or e |
Letter E |
Exponential sign.
|
Forces exponential notation. |
||
, |
Comma |
Thousand separator.
|
|
||
. |
Period |
Decimal separator.
|
|
||
|
Space |
Place holder for multiline breaks.
|
|
||
( <Format> ) |
Bracketed Expression |
Parenthesized negative format. |
Should only be used in a secondary format string.
|
||
+ |
Plus sign |
Forces the display of a significant digit to the left of the decimal point if the same is not specified, and the display of the exponential sign.
|
Should only be used immediately after the exponential sign. |
||
- |
Minus sign |
Forces the display of a significant digit to the left of the decimal point.
|
Should only be used immediately after the exponential sign. |
||
|
|||||
Examples |
Number |
|||
Format |
1234 |
-1234 |
0.5 |
0 |
<None> |
1234 |
-1234 |
0.5 |
0 |
0 |
1234 |
-1234 |
1 |
0 |
0.00 |
1234.00 |
-1234.00 |
0.50 |
0.00 |
#.## |
1234 |
-1234 |
.5 |
|
#,##0.00 |
1,234.00 |
-1234.00 |
0.50 |
0.00 |
#,##0.00;(#,##0.00) |
1,234.00 |
(1,234.00) |
0.50 |
0.00 |
#,##0.00;;Zero |
1,234.00 |
-1,234.00 |
0.50 |
Zero |
0.000E+00 |
1.234E-03 |
-1.234E-03 |
5.000E-01 |
0.000E+00 |
#.###E-0 |
1.234E-3 |
-1.234E-3 |
5E-1 |
0E0 |
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support