deepcalc
DocsSPARKLINE

SPARKLINE

View as markdown/docs/functions/sparkline.md Ask Claude about this pageOpens Claude with this page's address

Draws a mini line or bar chart from a range: options take charttype, color, negcolor, linewidth, ymin and ymax.

  • Excel: No equivalent
  • Google Sheets: Differs in detail
  • Returns: Svg

Examples

=SPARKLINE(A1:A4)
A
1 10
2 20
3 30
4 40
Result

Syntax

SPARKLINE(data, [options])
data
range required
options
any optional
FROMBYTESConverts byte array to integer. GENERATEIDGenerates unique ID with prefix and random suffix. HASHHex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGEShows an image from a url: the browser loads it, the engine does not fetch. ISINChecks if value is in a range or comma-separated list. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column.