Chartlark docs

1. Data

The first row is column names. Paste cells copied from Google Sheets, Excel or Numbers, open a CSV, TSV or JSON file, link a Google Sheet (shared as "Anyone with the link can view"; the tab in the link is the one read), or link a JSON file on GitHub or npoint. Up to 1,000 rows.

Numbers are read the way spreadsheets show them: $1,200, 12%, (300) for negatives, 1.2k, and comma decimals like 3,5. Empty cells, dashes and words are gaps, never zeros, and the panel tells you how many it found.

2. Chart types

TypeColumnsOptions
Column, BarCategories, then one or more seriesGrouped, stacked or 100%
Line, AreaCategories, then seriesStraight or smooth, points; areas overlap, stack or fill 100%
Pie, DonutSlices and one value columnMore than eight slices are grouped as "Other"; negative values are left out and reported
Scatter, BubbleX, Y, optional bubble size, colour by and point labelsBubble area follows the size value
ComboSeries as bars, plus the ones you tick as linesBars and lines share one axis. Two very different scales read better as two charts, so there is no second axis.

Up to eight series per chart: past eight, colours can't stay apart, so the panel asks you to split the chart.

3. Your colours and type

Under "Your colours and text styles", pick Paint styles or Colour variables. Styles and variables with names like Chart, Data viz or Series are used first, in order; change any series with its menu. You can also set the background, text, axis text and gridlines from them. "Add a library's colours" imports one colour collection from a library enabled in the file. On a dark chart, a variable collection with a mode named Dark switches to it.

Title and label text can use your text styles. If a style's font isn't available on your computer, Chartlark uses Inter and says so.

Patterns and area washes can't sit on a paint style (a style replaces every fill on a layer), so those layers get the style's colour as a value and the panel tells you. Colour variables keep patterns linked.

4. Editing and refreshing

Each chart frame remembers its settings and its data (only the columns it uses when the data is large). Select the chart, or anything inside it, and click Edit: change anything, then Update chart re-draws the same frame in place, keeping its position and any name you gave it. Insert copy makes a second chart instead.

Charts made from a Google Sheet or JSON link show Refresh data, and Refresh all re-draws every linked chart on the page. Each insert, update or refresh is one undo step.

5. Layers

The chart is a frame with vertical auto layout: Header (title and subtitle), Legend (wrapping auto layout), and Plot. Inside Plot: Gridlines, Y axis, X axis, one group per series (Bars: Revenue, Line: Visits), and Value labels. Bars are rectangles with rounded data ends, slices are ellipses with arcs, lines and areas are vectors. Every layer is named after its category or value.

6. Accessibility

Before you insert, the panel checks text contrast (4.5:1), mark contrast against the background (3:1, WCAG 1.4.11), and every touching pair of colours as seen with red-blind and green-blind vision (pie, scatter and bubble check every pair). Pattern fills (diagonal, cross-hatch, dots and more, on every series after the first) keep series apart for colour-blind readers and in greyscale print. Labels never use the series colour, so they stay readable.

What it doesn't do yet

Questions: hello@greatwork.company.