Tornado Chart

Let's have some fun today.

Here I have a sample of inventory of items that you would have on your desk. I have created a tornado chart by sorting the items by inventory largest first. I then use the =REPT function in combination with the pipe character on the keyboard to create the tornado chart. To finish the graphic I simply change the font to Playbill and center the column.

Take a look at the formulas and see if you can recreate this simple graph technique.
Play with the resizing factor in column I and see what it does to the graph. This resizing factor allows you to scale your chart to your data.

Note: The font in Column C is Playbill

No comments:

Post a Comment