You've used your 2 free formulas on this tool

Your last result is still on screen and copied. You only need membership to keep generating. Members get unlimited formula, sparkline, regexmatch, regexreplace, and conditional formatting generators, plus courses and tutorials when you’re stuck.

Free generations 2 / 2
  • Unlimited Formula, Sparkline, RegexMatch, RegexReplace, and Conditional Formatting generators
  • Step-by-step Google Sheets courses and tutorials
  • New tools and templates as they ship

Google Sheets tool

SPARKLINE Generator

Describe the mini chart you want—line, column, bar, or win/loss—and get a =SPARKLINE() formula ready to paste into any cell.

Two fields. One click. Your formula copies to the clipboard when it's ready.

Build your SPARKLINE formula

Chart type, colors, axis, max scale—be specific.

Blank defaults to A1.

2 free generations · Members generate without limits

Output

=SPARKLINE(A1:A5, {"charttype","column"; "axis", true})

Chart recipes

SPARKLINE examples for Google Sheets

Mini line, column, bar, and win/loss charts inside a single cell. Load any card into the generator above, or paste the formula straight into your sheet.

Column

Red column chart with axis

Vertical bars in one cell with a visible axis.

=SPARKLINE(A1:A5, {"charttype","column"; "axis", true; "axiscolor", "red"})
Bar

Horizontal bar chart with max scale

Stacked bar sparkline capped at a maximum value.

=SPARKLINE(A2:E2,{"charttype","bar";"max",40})
Line

Smooth line trend

Simple line chart for a row of numbers.

=SPARKLINE(B2:G2, {"color", "green"; "linewidth", 2})
Win/loss

Win/loss streak

Positive vs negative outcomes in a compact column.

=SPARKLINE(C1:C12, {"charttype","winloss"; "color", "blue"; "negcolor", "red"})

Need unlimited generations across every tool?

Upgrade once, skip usage limits, and move from idea to final formula without stopping.

Unlock unlimited generations

Use it in Sheets

Click any cell, paste your formula, and press Enter. SPARKLINE draws a tiny chart inside that cell—no separate chart object required.

Google SPARKLINE docs

Need a different formula?

For VLOOKUP, QUERY, ARRAYFORMULA, and more, try the full Formula Generator.

Formula Generator

Google Sheets Tools

Discover Google Sheets tools for anyone building spreadsheets, automations, and data workflows.