Another installment from Insomniac Software Inc.
I’ve added a page on my web site about Dot Plots. These are like a line chart turned on its side, with labels up the left hand axis, and dots positioned horizontally according to the plotted value. Or they’re like bar charts with a hidden bar and a dot at the end of the bar.
On my web page, I link to studies of the relative effectiveness of dot plots vs. bar charts, and I give tutorials on how to produce worksheet function (in-cell) and conventional chart versions of dot plots.
I also have built a utility to aid in construction of dot plots without having to remember all those stupid steps. The utility lets you select the data and choose from a few options, then spit out a nice dot plot. The Dot Plot utility is designed to work in Excel versions 2000, 2002, and 2003; it has not been tested in any Macintosh version or in Excel 97 or 2007, it may or may not work on these versions. The Dot Plot utility is a beta version, available at no cost in exchange for useful feedback. Ultimately it will be incorporated into a commercial Advanced Charting utility. The user interface looks like this:
and the output typically looks like this:
The Dot Plot utility is available at Dot Plots, which also has instructions for its installation and use.
I welcome any comments and suggestions, and will probably implement most reasonable feature requests.