KaziDocs

In-Cell Visuals functions

Reference for all 4 In-Cell Visuals functions in Kazi Sheets, with syntax and examples.

Sparklines, progress bars and ratings drawn inside a cell. Kazi Sheets has 4 In-Cell Visuals functions. Type = in a cell, start typing a name, and Kazi suggests it.

FunctionWhat it does
DELTADisplays percentage delta change indicator (▲ +15.2% or ▼ -8.4%).
PROGRESSRenders a live visual progress bar inside the cell.
RATINGRenders executive star ratings (e.g. ★★★★☆).
SPARKLINERenders a live in-cell SVG trendline sparkline chart.

DELTA

Displays percentage delta change indicator (▲ +15.2% or ▼ -8.4%).

Syntax

DELTA(current_value, previous_value)

Example

=DELTA(B4, B3)

PROGRESS

Renders a live visual progress bar inside the cell.

Syntax

PROGRESS(percentage_0_to_100)

Example

=PROGRESS(78)

RATING

Renders executive star ratings (e.g. ★★★★☆).

Syntax

RATING(score, [max_score])

Example

=RATING(4, 5)

SPARKLINE

Renders a live in-cell SVG trendline sparkline chart.

Syntax

SPARKLINE(range)

Example

=SPARKLINE(B2:D2)