Excel in-cell graphing

Found this at: http://www.juiceanalytics.com/weblog/?p=236

The bar graphs are built using the Excel REPT function which lets you repeat text a certain number of times. REPT looks like this:

=REPT(text,number_of_times)

For instance, REPT(”X”,10) gives you “XXXXXXXXXX”. REPT can also repeat a phrase; REPT(”Oh my goodness! “,3) gives “Oh my goodness! Oh my goodness! Oh my goodness! ” (my daughter’s an Annie fan).

For in-cell bar charts, the trick is to repeat a single bar “|”. When formatted in 8 point Arial font, single bars look like bar graphs. Here’s the formula behind the bars:

Also, they followed with this http://www.juiceanalytics.com/weblog/?p=239

Henk was first out of the gate with a great suggestion that two columns could be used to show positive and negative values. What he’s thinking of looks like this: