Version: Tested with Excel 2003
Keywords: in-cell graph, in-cell chart, text chart graph
In-cell graphs are built in Excel 2007, but these are notorously hard to read and actually does more to confuse the reciever than anything else. There are an alternative option which is very simple to use. Using the REPT function in excel repeats a symbol or string x times. The syntax is:
=REPT($string, repetions)
Now assume we have a column (A) of data, adding =REPT(“|”;A2/5) in the adjecent column (B) would yield something similar to the image below, after som simple formatting.
The use of such in-cell graphs? Well, I’m sure you can think of one.
This article was originally published on bloggpro.com.
Popularity: 3% [?]