How to Make In-cell Bar Charts (Text Sparklines) in Excel
Sometimes you just want to eyeball a column — which rows are big, which are small — without stopping to insert a chart. An in-cell bar chart turns each number into a little text bar built from block characters, scaled across the column, so the shape of the data jumps out right there in the grid.
Last updated: August 2026
| Sales | Chart (new column) | |
|---|---|---|
| 20 | → | ██ |
| 60 | → | ██████ |
| 100 | → | ██████████ |
Why Excel makes this hard
The classic REPT("|", value) trick draws a bar of pipe characters — but you have to scale it by hand so the largest value fits the width, and a raw run of pipes looks crude next to your data. Native Sparklines are fiddly to insert across many rows, they don't copy as text, and they render inconsistently across Windows, Mac, and Excel on the web. And a real chart object — with axes, a legend, and a plot area — is overkill for a quick at-a-glance read of one column.
The 1-click way — Tellsheet's In-cell Bar Chart
Select the range and run In-cell Bar Chart. Choose a bar length, pick smooth blocks (█▉▊ for sub-character precision) or a plain style (# or |), and decide whether to scale from zero or from the column minimum to stretch out close values. It writes a scaled text-bar column to a new sheet beside your data — plain text you can copy anywhere, no drawing layer, no floating objects. Pairs well with Frequency Table and Bucketize / Bin Values.
Frequently asked questions
Is this a real chart object?
No — the bars are text characters written into cells, so there's no drawing layer and they copy as plain text into any app.
Which characters does it use?
Smooth block characters (█▉▊) for finer steps, or plain # / | if you want maximum compatibility.
How does the scaling work?
Values are scaled so the largest fills your chosen bar length. Scale from zero, or from the column minimum to exaggerate small differences.
Does it work on Mac and the web?
Yes — because it's just text, it renders the same on Windows, Mac, and Excel on the web, unlike native Sparklines.
Related Excel guides
See your column's shape at a glance
In-cell Bar Chart turns a numeric column into scaled text bars on a new sheet — no chart object, copies as plain text, works everywhere.
Get Tellsheet free See pricing