Progress Bar in Google Sheets: REPT Formula vs SPARKLINE
Both methods show progress in one cell. SPARKLINE renders a mini chart; REPT builds plain text you can copy, drag down, and print cleanly. Here's when each one fits your sheet.
Quick answer
SPARKLINE draws a mini chart inside the cell. REPT builds a plain text bar you can copy, drag down, and share in templates. Use SPARKLINE when you want chart styling; use REPT when you want portable text that prints cleanly.
At-a-glance comparison
| Category | REPT text bar | SPARKLINE |
|---|---|---|
| Output type | Plain text characters inside the cell | Mini chart rendered in the cell |
| Copy and drag down | Formula copies cleanly; preview matches in every row | Works, but chart options are harder to read in the formula bar |
| Printing and PDF export | Text bars export as visible characters | Charts may shrink or lose color in some exports |
| Custom styling | Pick any character: blocks, emoji, CHAR codes | Chart colors and bar orientation via SPARKLINE options |
| Learning curve | One REPT pattern; swap characters for themes | Options JSON; color and axis tuning takes practice |
| Best for | Template sellers, habit trackers, stakeholder tables | Dashboard cells that need chart-like polish |
Side-by-side formulas
REPT block bar
Put current value in A1 and goal in B1 (use 100 for percent).
=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))
████████░░
SPARKLINE bar
Put current value in A1 and goal in B1, or pass a pre-calculated ratio.
=SPARKLINE(A1/B1,{"charttype","bar";"max",1})
[in-cell bar chart]
REPT text bar
REPT repeats a character (block, shade, emoji) based on a ratio between A1 (current) and B1 (goal). The result is plain text inside the cell. No chart editor, no add-on, and the formula copies like any other string.
SPARKLINE
SPARKLINE renders a miniature bar or line chart inside one cell. Options control color, axis max, and chart type. It looks more like a chart and updates when the underlying value changes.
Details
When REPT text bars win
Choose REPT when the bar must live inside a normal cell, copy to collaborators without chart quirks, and stay readable when printed. Text bars also pair well with emoji and CHAR symbols for themed trackers.
When SPARKLINE wins
Choose SPARKLINE when you want a bar that behaves like a chart: color gradients, vertical orientation, or hiding completed segments. If you are already comfortable with SPARKLINE options, keep using them for dashboard polish.
Can you use both?
Yes. Many sheets show a SPARKLINE bar in one column and a REPT label in the next. SPARKLINE tutorials cover chart styling; the progress bar library has dozens of REPT text variants.
Choose REPT text bar when…
- •You sell or share templates and need paste-ready formulas
- •The bar must print or export to PDF as visible text
- •You want emoji, CHAR, or themed characters in the bar
- •You are building long columns of identical progress rows
Choose SPARKLINE when…
- •You want chart colors without conditional formatting
- •The bar is part of a dashboard that already uses SPARKLINE
- •You need vertical bars or color-changing options
- •You are following an existing sparkline tutorial workflow
Related pages
Common questions
- Which is easier for beginners?
- REPT is usually faster to paste: one formula, visible characters, no options JSON. SPARKLINE is easy once you know the options syntax, and Better Sheets sparkline tutorials walk through it step by step.
- Which works better in printed reports?
- REPT text bars stay visible as characters in print and PDF export. SPARKLINE charts can shrink or lose color depending on export settings.
- Can I use both on the same sheet?
- Yes. Use SPARKLINE for dashboard polish and REPT for columns you copy, share, or print. Many trackers show a numeric percent plus a REPT bar in the next cell.
- Do REPT bars work with emoji?
- Yes. Swap the block characters for emoji or use CHAR and UNICHAR for symbol sets. Browse the progress bar formula library for dozens of themed variants.
Learn the method you picked
Members get video courses on REPT, CHAR, and SPARKLINE, plus hundreds of Google Sheets tutorials. Copy-paste formulas on the playground stay free.