How to Make a Tornado Chart in Excel (Sensitivity Analysis)

Learn how to make a Tornado Chart in Excel, that you can use for Sensitivity Analysis or for prioritizing Costs (and risks) against Benefits for your product or project. Check it out!

Timestamps:
00:00 Tornado Chart overview
00:48 Creating the heading area
01:37 Creating the Features table
03:18 Creating the Prioritizer column
04:12 Preserving the formulas with a Table
05:11 Creating the Tornado Chart
05:44 Putting the Axis on the left
06:40 Prioritizing costs and benefits
07:38 Making a Dynamic Chart Title
08:15 Finished Tornado Chart

[redbaron]

This channel is a gem. David you really are under appreciated and under subscribed. I really cannot thank you enough for the knowledge you have shared with us through your videos. Much gratitude from India ❤.

[madusankagd]

On March 19th, 2024, I successfully passed the PMP exam with ABOVE TARGET scores in all three domains. The videos by Mr. David, featuring 200 Agile questions, 100 Waterfall questions, and 150 PMBOK questions, were instrumental in helping me prepare and pass the exam. I am immensely grateful for the valuable effort you put into creating these videos. Best wishes for your future endeavors, and once again, thank you very much.

[wildwahid]

Realy Great Person and great explainantion, I've learned a much, Thank you Sir

[sameerdakhane]

Hello David
Want to thank you for your great content and presentation due to which I could pass my PMP with above target score. Wish you even more success🎉🎉

[pnkjgrko]

How can we make sensitivity plot if the each options has 1 positive value and 1 negative values? for ex. if I vary price from 10 to 15$, the loss converts to profit from -2 million to 1 million positive.