archive

Archive for the ‘Excel’ Category

Indexation vs Standardized Normalization

Monday, October 15th, 2007

Indexation vs Standardized NormalizationJust a quick comparison of two methods: indexation and standardized normalization. Given are three variables – two on emissions and GDP per Capita. The s.n. gives differences in small values a higher visibility, whereas the indexation allows to read more precisely the evolution (“a raise of 35%”). Disadvantage of latter is surely the choice of the “common” year…

MicroCharts – or Sparklines

Wednesday, August 8th, 2007

picture-12.pngThe use of sparklines has been already highlighted. Here is a nice add-on (not for free) that allows to use different graph styles. Looks really nice and clean.

In-Cell Bar Charts

Tuesday, August 7th, 2007

excel_rept1.gifGreat idea and easy approach to develop a lightweight data exploration tool in Excel. Here and here.

Nice Graphic

Tuesday, August 7th, 2007

cancergraphfull.gifNice graphic from the New York Times.