Category Archives: Excel

NanoCharts milestone release v0.51

October 26, 2007 Jesper DevLog, Excel

Keywords: Nanocharts, sparklines, VBA, in-cell graphing Version: Tested on Excel 2003. Download: NanoCharts public beta 0.51 (downloaded 1316 times) Popularity: 10% [?]

Popularity: 10% [?]

8 comments

Creating histograms in Excel

October 25, 2007 Jesper Excel

Keywords: histogram, normal distribution, Excel 2003, Box-Muller transformation, column chart Version: Should work with any version. Tested with Excel 2003. Popularity: 19% [?]

Popularity: 19% [?]

2 comments

NanoCharts sparklines Add-in beta for public testing

October 22, 2007 Jesper DevLog, Excel, Scripting

Keywords: NanoChart, Microcharts, Sparklines, Excel, VBA, Macro Download: NanoCharts public beta 0.50 (downloaded 501 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 … Continue reading →

Popularity: 17% [?]

2 comments

Automatic custom labels on Excel scatter plot

October 17, 2007 Jesper Excel, Scripting

Keywords: Excel, custom labels, XY plot chart, scatter plot, macro Version: Tested on Excel 2003 and Excel 2007 Download: Quite frequently there is a need to display custom lables in a standard Excel XY-plot. Unfortunately Excel lack a native function … Continue reading →

Popularity: 17% [?]

11 comments

Box plot for Excel 2007

October 15, 2007 Jesper Excel

Keywords: Boxplot, box plot, stem and leaf plots, Excel 2007, how to make Version: Excel 2007 Dowload: Since the previous entriesI have recieved quite a few questions about Box-plots in Excel 2007, so I decided I should describe one way … Continue reading →

Popularity: 100% [?]

61 comments