I've been asked to write some code to automate the creation of a tornado chart and don't know where to get started. I sort of understand what they are and am pretty good with VBA (and the chart object) so does anyone have some hints to get me started on what I need to do? I did find an add-in that does this but I need to write it myself so it generates/updates the chart from a button click.

Deb <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15>