Module insert 

Insert tab: tables, charts, sparklines, pictures, shapes, hyperlinks, comments and notes, conditional formatting (Home › Styles) and symbols.

Functions

build_chart

The chart insert.chart would insert for these params, without inserting it: the sheet it goes on and the chart (previews in the Recommended Charts dialog).

chart_kind

recommend_charts

Chart types that suit the shape of the data, best first, as (type, subtype, label) for insert.chart. Our own heuristic from the shape of the block (series count, points per series, text categories, negative values), not a copy of Excel’s ranking: two numeric columns without labels → scatter; one short series → column, pie, bar; long series → line; several series → clustered and stacked columns and bars, line.

scatter_x_from_first

A scatter plot of a block without category labels takes its first column (or row) as the X values of the others, as Excel does: two plain columns make one series of points, not two (#428).

series_from_range

Builds series from a block: first row/column as names/categories when they’re text.

specs