Note: this post is from 2006, outbound links may be broken.

Excel in-cell graphing

Related: , , Posted in random posts on Aug 11, 2006 - comment 0 comments

Juice Analytics has a nice post on in-cell graphing in Microsoft Excel.

The basic idea is to use the data of a cell in a formula that repeats a character to represent a nice bar. Excel’s REPT function does exactly that:

=REPT(text,number_of_times)

Excel REPT function to create in-cell bar graphics

Some readers explored this idea and came up with some nice variations.

Synapse Audio DUNE 2

Recommended sounds