Value Axis > Number Format
1. The Number Formatting controls the number label format in value axis, to enable this function make the toggle button true and its function menu will appear as shown in figure below:
2. The value axis label format - In the value Axis label format, user can add a particular format in the textbox to make changes to the value axis label format as per requirement.
In Value Axis Format try different options as below to see how the number format changes.
- # this option will remove the thousand separators.
- #,### this options will add the thousand separators.
- #a this option will add an abbreviation.
- #,###.00 this option will add a two decimal.
- $#,### this option will add a $ Prefix to a value.
- #.ooa this option will add an abbreviation and add two decimal places.
- Keep the final value as $#.00a