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 of beta release of what will eventually be an Add-in for Excel. At present I have a working version that allow the user to insert some different NanoChart types and do some simple formatting selections. The current user form looks like this:

For now the user can insert only one chart at once, but this will probably change in the future. Also, data orientation and colors cannot be selected at the moment, but this will also likely be added to the next release. The resulting NanoCharts can be seen in the next picture.

To try this add-in, simply download the file, select any row of data and click “Insert NanoChart”, select the options you wamt in the User form and click OK. The NanoChart will be inserted in the cell immediately to the right of your selection.

Please give feedback and request features by posting comments to this post, or simply contact me via email. Enjoy.

Download: NanoCharts public beta 0.50 (downloaded 354 times)

Popularity: 24% [?]