excel in-cell bar graphs
11 August 2006
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]
roots of Middle-East conflict movie data signals on a spiral electoral college prediction tracker hidden cost of Iraq war movie credit crisis visualized museum data dashboard Berkman tag content network visualization funniest pie chart ever 2008 visualization challenge winners participative physical bar charts why we drink movie US elections reference frequency pyramid the graphic truth visual overview of your life
RSS 
