Value formatting

The format of values and labels shown in a chart is, by default, optimized based on your account's language setting. You can change it from value format in the chart's advanced settings. If you've changed the formatter, its setting takes priority regardless of the language setting.

Where to specify it

For example, on XY Chart, you can specify a formatter in the following places.

• Axis labels
  • Advanced settings > X axis / Y axis > Value format.
• Values in the tooltip
  • Advanced settings > Series > (series name) > Value format.
• Value labels (if Value labels are shown)
  • Advanced settings > Series > (series name) > Value labels > Value label format.

Use the button on the left of the input field to switch between the number formatter and the date formatter. The date formatter also offers presets in Format list.

Number formatter

The number formatter uses d3-format syntax. You can also use the number formatter builder to build the display format, precision, digit grouping, and so on.

For example, you can specify the following.

Setting	Number	Formatted result
.0f	12345.6789	12346
,.1r	12345.6789	10,000
-.1%	0.5	50%

You can also wrap d3-format syntax in { and }, and add a prefix or suffix around it (this is a Codatum-specific extension, not part of d3-format itself).

Setting	Number	Formatted result
{,d} JPY	12345.6	12,346 JPY
about {,d}%	50	about 50%

Date formatter

The date formatter uses Day.js syntax.

For example, you can specify the following.

Setting	Date	Formatted result
YYYY-MM-DD	2025-01-01	2025-01-01
YY/M/D	2025-01-01	25/1/1
MMMM YYYY	2025-01-01	January 2025