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