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





