Other Resources

How to Draw Some Useful Charts Not on Excel Menus

The resources below show that one can use Excel for graphs that are not on its menus. However, it is easier to use software designed to draw these graphs if you know the necessary language. R, an implementation of the S language, is open source software that is extremely powerful and is available at no cost from http://www.r-project.org.

1 BOX PLOTS

A number of websites give instructions for drawing box plots using Excel but most do not include outliers. Therefore, I prefer the utility of Jon Peltier since it does handle outliers. Sites include:

2 DOT PLOTS
Here are some sources that provide instructions for drawing dot plots in Excel or provide macros or utilities to do so. Jon Peltier’s utility and the instructions from processtrends.com and Exceluser.com can handle more than one series.
3 MONTH PLOTS
The link below provides instructions for creating a month plot using Excel. (web page of D. Kelly O Day)

http://www.processtrends.com/pg_charts_monthly_cycle_chart.htm

4 ARROW PLOTS
Send an email to naomi@nbr-graphs.com for a macro to draw arrow charts using Excel 2003.
5 MULTIPANEL PLOTS

The following sites give instructions for creating multipanel charts in Excel:

6 SPARKLINES
SPARKLINES
Edward Tufte introduced sparklines in his book Beautiful Evidence. Companies offering Excel add-ons to draw sparklines include BonaVista Systems and Bissantz. MicroCharts from BonaVista Systems is available from: http://www.microcharts.net
7 BULLET GRAPHS
BULLET GRAPHS

Bullet graphs are described in Information Dashboard Design by Stephen Few. Here are instructions for drawing bullet graphs as well as an inexpensive utility for drawing them:

http://www.exceluser.com/catalog/landbullet1.htm

OTHER USEFUL LINKS WHEN DRAWING GRAPHS