Skip to content
Ruled

Formulas, charts and pivot tables

Without a schema, the editor is a spreadsheet. Switch between the sample workbooks below.

kitchen-sink.xlsxLoads as you scroll to it

Try: change a number and watch the formulas and charts that use it; right-click a pivot table and choose Show Field List; right-click a range and insert a chart; drag a chart by its frame.

  • Kitchen sink: formatting, conditional formats, validation, notes, tables, names, dynamic arrays, LET and LAMBDA, and checkboxes.
  • Charts: radar, bubble, stock and 3-D charts, drawn from the cells.
  • Pivot table: units by region from a hundred orders, worked out again as they change.
  • Orders: a list to sort, filter and fill.

See Excel fidelity for what the editor shows, edits and keeps.