Formatting Properties
System Default
Using the systems default for number or date format.
Number / Currency / Percent
Decimal Places
Sets the number of decimal places.
Use Thousands Seperator
Enable or disable the thousands seperator.
Negative
Change the representation of negative values.
Abbreviation
Change the abbreviation for values, e.g. thousands shown as k.
Preview Value
You can enter a custom preview value.
Preview
Shows the current number format.
Note: By using the percent number format to show the values on the chart item (e.g. bars) the values will be calculated as a percentage to the total value of current group. If you need the original values with "%" character, please use the number pattern format with "0.00%".
Number Pattern
Pattern
Change the representation of values with a JAVA pattern.
Examples
Shows some examples for the most JAVA pattern. Copy with double click the selected example into the pattern field.
Preview Value
You can enter a custom preview value.
Preview
Shows the current number format.
For more information how to use the number pattern please see the Java tutorial: https://docs.oracle.com/javase/tutorial/i18n/format/decimalFormat.html
Date / Time / Date & Time
Date
Changes the format for date value.
Time
Changes the format for time value.
Preview
Shows the current date and time with the selected format.
Date Pattern
Pattern
Change the representation of values with a JAVA pattern.
Examples
Shows some examples for the most JAVA pattern. Copy with double click the selected example into the pattern field.
Preview
Shows the current date and time with the selected pattern.
For more information how to use the number pattern please see the Java tutorial: https://docs.oracle.com/javase/tutorial/i18n/format/simpleDateFormat.html.