Keywords: histogram, normal distribution, Excel 2003, Box-Muller transformation, column chart
Version: Should work with any version. Tested with Excel 2003.
Popularity: 22% [?]
Popularity: 22% [?]
25Oct07
Creating histograms in Excel
Keywords: NanoChart, Microcharts, Sparklines, Excel, VBA, Macro
Download: NanoCharts public beta 0.50 (downloaded 434 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: 20% [?]
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 to insert custom labels; the only options available are Series names, x- and y-values which often are totally [...]
Popularity: 19% [?]
15Oct07
Box plot for Excel 2007
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 to create decent looking box plots in Excel 2007. In my example I start with a set of [...]
Popularity: 100% [?]
11Oct07
NanoCharts add-in development
As I decided to develop the NanoCharts (a concept more known as Microcharts or Sparklines) into an Excel add-in I’ve started by specifying features and functionality and came up with the following list:
Three different types of charts; bar, line and dot
Possibility to have data in rows or columns
Selectable chart color
Optional x-axis
Option to display [...]
Popularity: 14% [?]
