Advertise here.

excelincell.jpg
an extremely simple technique for adding simple bar charts or sparkline-like diagrams within the cells of an Excel spreadsheet. the already built-in Excel REPT function repeats any text entry a certain number of times. for instance, REPT(”X”,10) results in “XXXXXXXXXX”. so the trick is to repeat specific characters, such as a single bar “|” to create data bars.
see also a similar implementation in the upcoming Excel 12 & an artistic take as Excel drawings.
[juiceanalytics.com & juiceaanalytics.com]

MORE

excelincell2.jpg

7 COMMENTS

Wow thats cool.

Fri 11 Aug 2006 at 9:38 PM

If you rotate the text direction, you should be able to to vertical bar charts as well. Neat trick.

Fri 11 Aug 2006 at 11:40 PM
James Wynn

I think this simple command has a lot of utility in GIS applications: you get a quick infographic within its spatial context. I've referenced your post as well as JA's in my last blog.

Cheers

Sat 12 Aug 2006 at 8:00 AM

This is super cool trick. I can't wait to check it out.

Mon 14 Aug 2006 at 7:47 PM

I see the new Excel in Windows Vista is going to be able to do this automatically.

Tue 15 Aug 2006 at 2:42 AM

I did this in MS Access 2.0 forms to nice effect back in '97. Different fonts have different widths for the | character, with some mods you can make almost solid bars.

Wed 16 Aug 2006 at 6:18 PM
the lemur

Really neat trick. Try using "g" as the character and Webdings as the font. You get completely solid bars.

Mon 21 Aug 2006 at 9:13 PM
ADD A COMMENT
Commenting has been temporarily disabled.