Number Formatting
The Axes & Legend panel contains options to change the number formats used on each axis. There are 22 different numerical formats available, including scientific notation and a custom format.
Auto Format
Turn this off to manually select a format type for each numeric axis.
Available Number Formats
Below is a list of available number formats within InstaCharts.
The examples listed below are formatted using the USA locale (US-en).
| Format Type | 0.053 | 1.4 | 1700 | 1539040 | 1539040111 | 1539040111777 |
|---|---|---|---|---|---|---|
| Abbr: All 4.2m | 0.1 | 1.4 | 1.7K | 1.5M | 1.5B | 1.5T |
| Abbr: All 4.23m | 0.05 | 1.4 | 1.7K | 1.54M | 1.54B | 1.54T |
| Abbr: Thousands 1.5k | 0K | 0.001K | 1.7K | 1539.04K | 1539040.111K | 1539040111.777K |
| Abbr: Millions 1.5m | 0M | 0M | 0.002M | 1.539M | 1539.04M | 1539040.112M |
| Abbr: Billions 1.5b | 0B | 0B | 0B | 0.002B | 1.539B | 1539.04B |
| Abbr: Trillions 1.5t | 0T | 0T | 0T | 0T | 0.002T | 1.539T |
| Integer: no separators 1234 | 0 | 1 | 1700 | 1539040 | 1539040111 | 1539040111777 |
| Integer: separators 1,234 | 0 | 1 | 1,700 | 1,539,040 | 1,539,040,111 | 1,539,040,111,777 |
| Decimal: 54.12 | 0.05 | 1.40 | 1,700.00 | 1,539,040.00 | 1,539,040,111.00 | 1,539,040,111,777.00 |
| Percent: 12% | 0.1% | 1.4% | 1,700% | 1,539,040% | 1,539,040,111% | 1,539,040,111,777% |
| Percent: (x100) 1200% | 5.3% | 140% | 170,000% | 153,904,000% | 153,904,011,100% | 153,904,011,177,700% |
| Currency: $3.50 | $0.05 | $1.40 | $1,700.00 | $1,539,040.00 | $1,539,040,111.00 | $1,539,040,111,777.00 |
| Currency: Abbr All $650k | $0.05 | $1.4 | $1.7K | $1.54M | $1.54B | $1.54T |
| Currency: Abbr Thousands $650k | $0K | $0.001K | $1.7K | $1539.04K | $1539040.111K | $1539040111.777K |
| Currency: Abbr Millions $650m | $0M | $0M | $0.002M | $1.539M | $1539.04M | $1539040.112M |
| Currency: Abbr Billions $650b | $0B | $0B | $0B | $0.002B | $1.539B | $1539.04B |
| Currency: Abbr Trillions $650t | $0T | $0T | $0T | $0T | $0.002T | $1.539T |
| Ordinal: 1st, 2nd, 3rd (not available in all locales) | 0th | 1st | 1,700th | 1,539,040th | 1,539,040,111th | 1,539,040,111,777th |
| Bytes: Converts bytes into KB, MB, etc. Ex: 1.95KB | 0B | 1B | 2KB | 1MB | 1GB | 1TB |
| Duration: Turns number of seconds into hours, minutes & seconds Ex: 0:04:59 | 0:00:00 | 0:00:01 | 0:28:20 | 427:30:40 | 427511:08:31 | 427511142:09:37 |
| Scientific: 5.02e10 | 5.3e-2 | 1.4e0 | 1.7e3 | 1.54e6 | 1.54e9 | 1.54e12 |
Scientific is the Auto format for Scientific columns, so their axes match the 5.02e10 style shown in the data table.
Customize a Number Format
Turn off Auto Format, then turn on Customize next to an axis to build its number format from a few simple choices. The Reset button next to the toggle puts the choices back to match the axis’s Auto format.
The choices are split across three tabs, and a preview under the Type tab shows sample numbers written with the format.
- Type: Number, Currency, Percent (12 shows as 12%) or Percent x100 (0.12 shows as 12%). Currency adds a symbol picker and a choice of where the symbol goes.
- Round: round to decimal places or significant figures, or leave the value as is. Pick an abbreviation, and keep trailing zeros such as 5.00 when rounding to decimal places.
- Format: choose how negative numbers look, add a prefix or suffix such as
km/h, and turn thousands separators on or off.
Abbreviations
The Abbreviate dropdown groups its units into business abbreviations, metric prefixes and scientific notation. Each unit lists what it stands for, along with an example.
| Abbreviation | Stands for | 0.0000045 | 1539040 | 50200000000 |
|---|---|---|---|---|
| Auto | Picks K, M, B or T for each value | 0 | 1.54M | 50.2B |
| Thousands (K) | Thousand, 1,000 | 0K | 1,539.04K | 50,200,000K |
| Millions (M) | Million, 1,000,000 | 0M | 1.54M | 50,200M |
| Billions (B) | Billion, 10⁹ | 0B | 0B | 50.2B |
| Trillions (T) | Trillion, 10¹² | 0T | 0T | 0.05T |
| Quadrillions (Q) | Quadrillion, 10¹⁵ | 0Q | 0Q | 0Q |
| Auto metric | Picks a metric prefix for each value | 4.5µ | 1.54M | 50.2G |
| Kilo (k) to Exa (E) | 10³, 10⁶, 10⁹, 10¹², 10¹⁵ and 10¹⁸ | |||
| Milli (m) to Atto (a) | 10⁻³, 10⁻⁶, 10⁻⁹, 10⁻¹², 10⁻¹⁵ and 10⁻¹⁸ | |||
| Scientific notation (e) | A number times a power of ten | 4.5e-6 | 1.54e6 | 5.02e10 |
The examples use 2 decimal places. The business abbreviation letters follow the chart’s number locale, so a chart set to Great Britain writes 1.54m and a chart set to Germany writes 1,54 Mio. Metric prefixes are written the same in every locale.
Scientific notation works with every type, so a currency axis can show $5.02e10. Thousands separators are hidden while scientific notation is picked, because the exponent already shows the size of the number.
Custom Formats
InstaCharts also supports custom formats. To use a custom format, select the last option in the list, “Custom Format”. A text field will pop up where you can enter in format.
The simplest pattern format is 0, and a common pattern is 0,0.[00]. The numeral pattern rules include:
-
Number of decimal places: The
.character turns on the option to show decimal places using a locale-specific decimal separator, most often.or,. To add trailing zeroes such as 5.00, use a pattern like0.00. To have optional zeroes, use the[]characters. -
Thousands separator: The thousands separator turns on the option to group thousands using a locale-specific separator. The separator is most often
,or., and sometimes. -
Accounting notation: Putting parentheses around your format like
(0.00)will use accounting notation to show negative numbers. -
Abbreviations: Adding the abbreviation character
awill abbreviate large numbers where possible. -
Percent: Adding the percent character
%will multiply the number by 100 and add a percent sign. -
Currency: Adding the currency character
$will show the number as a currency in the chosen locale. -
Positive Numbers: Adding a plus sign
+will show a plus sign before positive numbers. -
Ordinal: Adding ordinal formatting
0owill convert the number to an ordinal number system (1st, 2nd, 3rd, etc). Not all locales support ordinal formatting. -
Bytes: Adding the bytes character
bwill convert the number as if it were a number of bytes, and use an appropriate suffix (KB, MB, GB, etc) -
Duration: Adding duration formatting
00:00:00will convert the number as if it were a number of seconds, and display it as Hours:Minutes:Seconds. -
Custom: Encase the regular formatting rules in curly braces
{}; anything outside the curly braces will be copied over to the formatted number. Ex:{0.0} km/hwill format as4.5 km/h.
Custom Format Examples
Numbers and Currency
| Custom Format | 0.053 | 1.4 | -1700 | 1539040 | 1539040111 | 1539040111777 |
|---|---|---|---|---|---|---|
+$0.[00]a | $+0.05 | $+1.4 | -$1.7K | $+1.54M | $+1.54B | $+1.54T |
$0.[00]a | $0.05 | $1.4 | -$1.7K | $1.54M | $1.54B | $1.54T |
0,0.[00]a $ | 0.05 $ | 1.4 $ | -1.7K $ | 1.54M $ | 1.54B $ | 1.54T $ |
+$0.[00]a | $+0.05 | $+1.4 | -$1.7K | $+1.54M | $+1.54B | $+1.54T |
(0,0.00) | 0.05 | 1.40 | (1,700.00) | 1,539,040.00 | 1,539,040,111.00 | 1,539,040,111,777.00 |
0,0.[000]% | 5.3% | 140% | -170,000% | 153,904,000% | 153,904,011,100% | 153,904,011,177,700% |
0 % | 5 % | 140 % | -170000 % | 153904000 % | 153904011100 % | 153904011177700 % |
0o | 0th | 1st | -1700th | 1539040th | 1539040111th | 1539040111777th |
Abbreviated Numbers
Convert large numbers into thousands, millions, billions and trillions.
| Custom Format | 0.053 | 1.4 | -1700 | 1539040 | 1539040111 | 1539040111777 |
|---|---|---|---|---|---|---|
0.00a | 0.05 | 1.40 | -1.70K | 1.54M | 1.54B | 1.54T |
0,0.[0]aK | 0K | 0K | -1.7K | 1,539.04K | 1,539,040.11K | 1,539,040,111.78K |
0,0.[0]aM | 0M | 0M | 0M | 1.54M | 1,539.04M | 1,539,040.11M |
0,0.[0]aB | 0B | 0B | 0B | 0B | 1.54B | 1,539.04B |
0,0.[0]aT | 0T | 0T | 0T | 0T | 0T | 1.54T |
Bytes
Transform a number of bytes into megabytes, gigabites, etc.
| Custom Format | 0.053 | 1.4 | -1700 | 1539040 | 1539040111 | 1539040111777 |
|---|---|---|---|---|---|---|
0.00b | 0.05B | 1.40B | -1.66KB | 1.47MB | 1.43GB | 1.40TB |
0.00bb | 0.05B | 1.40B | -1.66KiB | 1.47MiB | 1.43GiB | 1.40TiB |
0.00bd | 0.05B | 1.40B | -1.70kB | 1.54MB | 1.54GB | 1.54TB |
0.00bitb | 0.05bit | 1.40bit | -1.66Kibit | 1.47Mibit | 1.43Gibit | 1.40Tibit |
0.00bitd | 0.05bit | 1.40bit | -1.70kbit | 1.54Mbit | 1.54Gbit | 1.54Tbit |
Duration
Convert number of seconds into a Hours:Minutes:Seconds format.
| Custom Format | 0.053 | 1.4 | -1700 | 1539040 | 1539040111 | 1539040111777 |
|---|---|---|---|---|---|---|
00:00:00 | 0:00:00 | 0:00:01 | -0:28:20 | 427:30:40 | 427511:08:31 | 427511142:09:37 |
Custom
Use curly braces {} to add a prefix or suffix to your number’s format. Enclose the regular format within {}, and put the prefix or suffix outside the braces.
| Custom Format | 0.053 | 1.4 | -1700 | 1539040 | 1539040111 | 1539040111777 |
|---|---|---|---|---|---|---|
{0.0}% | 0.1% | 1.4% | -1700.0% | 1539040.0% | 1539040111.0% | 1539040111777.0% |
{0,0.[0]} km/h | 0.1 km/h | 1.4 km/h | -1,700 km/h | 1,539,040 km/h | 1,539,040,111 km/h | 1,539,040,111,777 km/h |
$USD {0,0.00} | $USD 0.05 | $USD 1.40 | $USD -1,700.00 | $USD 1,539,040.00 | $USD 1,539,040,111.00 | $USD 1,539,040,111,777.00 |
Related
- Chart Text - set the number and time locale
- Labels - where formatted numbers appear on the chart
- Column Types - how numeric columns are detected
- Workspace Chart Defaults - set a default locale for new charts