Chart Functions

OpenSheets supports creating charts directly from formulas.

SPARKLINE

Embeds a miniature chart inside a single cell. Useful for inline data visualization without a full chart.

=SPARKLINE(data, [options])

Line Sparkline (default)

=SPARKLINE(B2:B12)

Bar Sparkline

=SPARKLINE(B2:B12, {"charttype", "bar"})

Column Sparkline

=SPARKLINE(B2:B12, {"charttype", "column"})

Win/Loss Sparkline

=SPARKLINE(B2:B12, {"charttype", "winloss"})

CHART

Creates a chart object from a data range.

=CHART(data_range, chart_type, [title])

=CHART(A1:B10, "bar", "Sales by Region") -- creates a bar chart from the data with the given title.

Supported chart types: bar, line, pie, column, area, scatter.

Tip: For full chart creation with detailed options (axis labels, colors, legends), use the chart dialog available from the Insert menu. Formula-based charts are best for quick inline visualizations.