Browsing the blog archives for October, 2007
Just a short note found on the MS Excel team blog stating that the Microsoft research team has developed an add-in that enables users to browse the web via the add-in and select data to import to Excel, all while the add-in will adapt and learn from your selections.
The system extracts data by learning from [...]
Popularity: 64% [?]
Excel is known for it’s excessive use of clutter and unnecessary “eye candy” (a.k.a as chart junk) in their default chart types. However, you can correct this with a few clicks to produce nice looking charts with at least less distracting layout. Have a look at this screencast for a quick walk-through on how to clean [...]
Popularity: 9% [?]
Keywords: Nanocharts, sparklines, VBA, in-cell graphing
Version: Tested on Excel 2003.
Download: NanoCharts public beta 0.51 (downloaded 1068 times)
Popularity: 14% [?]
Popularity: 14% [?]
Keywords: histogram, normal distribution, Excel 2003, Box-Muller transformation, column chart
Version: Should work with any version. Tested with Excel 2003.
Creating histograms in Excel can be a chore since there is no native function to do this, but by using a few tricks it can still be done with relative ease. First of a we need some [...]
Popularity: 26% [?]
Keywords: NanoChart, Microcharts, Sparklines, Excel, VBA, Macro
Download: NanoCharts public beta 0.50 (downloaded 354 times)
Some time ago I announced a mini-project called NanoCharts, which is an implementation of Edward Tuftes Sparklines concept. Sparklines (and NanoCharts) are basically small, word sized graphics for high density visualization of data. I have been working to make available a sort [...]
Popularity: 24% [?]
