Friday, October 1, 2010

Tornado Charts

I know we've all struggled with constructing a tornado chart to represent our data in the group assignment we did in class. I did a little research and found some helpful websites where the authors explain how to do it in a very easy way. What you basically need to do is make a table of your data, select the whole range, then go to the insert tab and click on charts to choose the stacked bar chart. After that, right click on the Y (vertical) axis, select format and tick categories in reverse order and next to horizontal axis crosses at maximum value. and VOILA your tornado chart is done!! http://peltiertech.com/Excel/Charts/tornadochart.html

There are so many ways to do it; here is another easy process you may like to use:
http://8020world.com/jcmendez/2007/02/business/easy-creation-of-tornado-charts-in-excel-5-steps-no-add-ins/

No comments:

Post a Comment