Create a basic Tornado Chart in Excel 2016. Useful in showing sensitivities either deterministic or probabilistic. See my other video on Probabilistic Tornados.
Wonderful video. I love this so much. Quick, easy, to the point, clear. It is a mystery to me as to why MS Excel does not have these settings as the default
These are data labels. The labels will initially come in as values. Click on one of the numbers and right click to edit data label. There is an option to use Labels. You then specify a range. Then unclick the number because you don't want both. Brian Putt (Brian@theputts.com)
On the edit line, if you highlight a cell reference, and hit F4 it puts $ on the reference. Then the cell reference will not change when you copy the cell. Does this address your question?
The base value for a deterministic tornado is generally the result using the Most Likely outcomes for each uncertainty. Remember the most likely is NOT the Expected Value generally. However, the base value could be any value you really want to use. For a probabilistic tornado, perhaps discussed in another video, the base value should be the EV of the project. You will see this in the videos about Cost and Schedule Risk Analysis. I am posting another video on that subject today. Hope this helps. Brian Putt.
Wonderful video. I love this so much. Quick, easy, to the point, clear. It is a mystery to me as to why MS Excel does not have these settings as the default
Thank you for making my work easy for me.
Thank you very much , it helped me a lot
Thanks Brian!
Gracias!!!
Thanks. very helpful
Many thanks!
Thank you soo much!!!!!
Thank you, this helps a lot :p
This is what I’m working on
GOOOOOOOOOOOOOOOD
THANKS
Thank you for this! In the legend: how do I put "high" to the right side and "low" to the left?
These are data labels. The labels will initially come in as values. Click on one of the numbers and right click to edit data label. There is an option to use Labels. You then specify a range. Then unclick the number because you don't want both. Brian Putt (Brian@theputts.com)
How to put both side same legand???😢😢
how to make the first row (variable 1) still in the first row at the chart?
On the edit line, if you highlight a cell reference, and hit F4 it puts $ on the reference. Then the cell reference will not change when you copy the cell. Does this address your question?
Is there a formula for finding the base value?
The base value for a deterministic tornado is generally the result using the Most Likely outcomes for each uncertainty. Remember the most likely is NOT the Expected Value generally. However, the base value could be any value you really want to use.
For a probabilistic tornado, perhaps discussed in another video, the base value should be the EV of the project. You will see this in the videos about Cost and Schedule Risk Analysis. I am posting another video on that subject today. Hope this helps. Brian Putt.
There are overlap data here. It should be adjusted a little bit to have a perfect tornado
Thanks. Think I have posted some new videos that change the Overlap to 100%.
hi sir, how to get mid line 5?
Thought the video covered that. If you edit the axis there is an option to set the axis. Am I answering your question?
Sorry, sir, is there a formula to get the center line? (in your video the result is 5)@@brianputt984
@@brianputt984 how did you get the number 5 ?