Skip to content

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.

You can select a different number format per each numerical axis.
You can select a different number format per each numerical axis.

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 Type0.0531.41700153904015390401111539040111777
Abbr: All 4.2m0.11.41.7K1.5M1.5B1.5T
Abbr: All 4.23m0.051.41.7K1.54M1.54B1.54T
Abbr: Thousands 1.5k0K0.001K1.7K1539.04K1539040.111K1539040111.777K
Abbr: Millions 1.5m0M0M0.002M1.539M1539.04M1539040.112M
Abbr: Billions 1.5b0B0B0B0.002B1.539B1539.04B
Abbr: Trillions 1.5t0T0T0T0T0.002T1.539T
Integer: no separators 1234011700153904015390401111539040111777
Integer: separators 1,234011,7001,539,0401,539,040,1111,539,040,111,777
Decimal: 54.120.051.401,700.001,539,040.001,539,040,111.001,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)0th1st1,700th1,539,040th1,539,040,111th1,539,040,111,777th
Bytes: Converts bytes into KB, MB, etc. Ex: 1.95KB0B1B2KB1MB1GB1TB
Duration: Turns number of seconds into hours, minutes & seconds Ex: 0:04:590:00:000:00:010:28:20427:30:40427511:08:31427511142:09:37
Scientific: 5.02e105.3e-21.4e01.7e31.54e61.54e91.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.

AbbreviationStands for0.0000045153904050200000000
AutoPicks K, M, B or T for each value01.54M50.2B
Thousands (K)Thousand, 1,0000K1,539.04K50,200,000K
Millions (M)Million, 1,000,0000M1.54M50,200M
Billions (B)Billion, 10⁹0B0B50.2B
Trillions (T)Trillion, 10¹²0T0T0.05T
Quadrillions (Q)Quadrillion, 10¹⁵0Q0Q0Q
Auto metricPicks a metric prefix for each value4.5µ1.54M50.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 ten4.5e-61.54e65.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 like 0.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 a will 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 0o will convert the number to an ordinal number system (1st, 2nd, 3rd, etc). Not all locales support ordinal formatting.

  • Bytes: Adding the bytes character b will 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:00 will 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/h will format as 4.5 km/h.

Custom Format Examples

Numbers and Currency

Custom Format0.0531.4-1700153904015390401111539040111777
+$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.051.40(1,700.00)1,539,040.001,539,040,111.001,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 %
0o0th1st-1700th1539040th1539040111th1539040111777th

Abbreviated Numbers

Convert large numbers into thousands, millions, billions and trillions.

Custom Format0.0531.4-1700153904015390401111539040111777
0.00a0.051.40-1.70K1.54M1.54B1.54T
0,0.[0]aK0K0K-1.7K1,539.04K1,539,040.11K1,539,040,111.78K
0,0.[0]aM0M0M0M1.54M1,539.04M1,539,040.11M
0,0.[0]aB0B0B0B0B1.54B1,539.04B
0,0.[0]aT0T0T0T0T0T1.54T

Bytes

Transform a number of bytes into megabytes, gigabites, etc.

Custom Format0.0531.4-1700153904015390401111539040111777
0.00b0.05B1.40B-1.66KB1.47MB1.43GB1.40TB
0.00bb0.05B1.40B-1.66KiB1.47MiB1.43GiB1.40TiB
0.00bd0.05B1.40B-1.70kB1.54MB1.54GB1.54TB
0.00bitb0.05bit1.40bit-1.66Kibit1.47Mibit1.43Gibit1.40Tibit
0.00bitd0.05bit1.40bit-1.70kbit1.54Mbit1.54Gbit1.54Tbit

Duration

Convert number of seconds into a Hours:Minutes:Seconds format.

Custom Format0.0531.4-1700153904015390401111539040111777
00:00:000:00:000:00:01-0:28:20427:30:40427511:08:31427511142: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 Format0.0531.4-1700153904015390401111539040111777
{0.0}%0.1%1.4%-1700.0%1539040.0%1539040111.0%1539040111777.0%
{0,0.[0]} km/h0.1 km/h1.4 km/h-1,700 km/h1,539,040 km/h1,539,040,111 km/h1,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