Dear community members,
I want to create a Tornado diagram with Apple Numbers.
I did some google search but pretty much everything that I got is related to Excel.
Any info or links regarding this would be helpful as to how can I create a tornado diagram with apple numbers.
Thanks.
From your screenshot it looks as if you may already have found a solution you like, but here is how I implemented a simple Tornado Diagram in Numbers, similar to the Excel example described at http://www.pmhub.net/PMD/cornelius-fichtner-pmp-pmp-exam-tip-how-to-use-the-torn ado-diagram/.
The basic approach was to lay out the cases in a table, set up additional calculation tables for each variable, and then construct a source table for the chart.
Formulas:
'Cases':
| B5: | =B2×(B3−B4) |
| C5: | =C2×(C3−C4) |
| D5: | =D2×(D3−D4) |
'Volume':
| B5: | =B2×(B3−B4) |
| C5: | =C2×(C3−C4) |
'Price'
| B5: | =B2×(B3−B4) |
| C5: | =C2×(C3−C4) |
'Cost':
| B5: | =B2×(B3−B4) |
| C5: | =C2×(C3−C4) |
'Chart Data':
| B2: | =Price::B5 |
| C2: | =Cases::C5−Price::B5 |
| D2: | =Price::C5−Cases::C5 |
| B3: | =Cost::B5 |
| C3: | =Cases::C5−Cost::B5 |
| D3: | =Cost::C5−Cases::C5 |
| B4: | =Volume::B5 |
| C4: | =Cases::C5−Volume::B5 |
| D4: | =Volume::C5−Cases::C5 |
I selected all columns in 'Chart Data' and inserted a '2D Stacked Bar' chart, then set the fill for the LeftPad series to 'No Fill' under Style:
SG
Hi a_for_apple,
This sounds like an interesting question!
Is it something to do with risk analysis?
Please post a Screen Shot of a small part of your data table (command shift 4 and drag) to help us understand and help.
More information on your aim will lead to a solution 🙂.
Regards,
Ian.
Hi Ian,
Thanks for your response.
Yes you are right. I want to do a sensitivity analysis so see how sensitive a variable is to a certain variation of inputs. Actually I am myself in the process of understanding a tornado diagram and want to create one to see how it really works. Google search mainly shows only Excel related information and the templates from excel dont seem to work in Numbers.
Here is an example. I want to calculate profit using formula: Profit = Volume * (Price – Cost).
For each of my input variables (volume, price and cost), I have the base case (median) and the best and worst case values. Using base case values for volume, price and cost, I find the profit to be $62 million and draw a vertical line at 62 on the horizontal scale. Now in this formula I put the best and worst case values of each of these variables one at at a time to find out what will be the profit for each such change. Plotting all these values and sorting the highest sensitivity (biggest bar) top-to-bottom will give me the tornado. From the tornado I see which variable (in this case price) is the most sensitive to profit.
Glad it helped. I've found that refreshing my memory on what I was doing with those formulas in 'Chart Data' is much easier when in Numbers > Preferences I turn on 'Use header names as labels.' Then I click a cell in 'Chart Data' and see something like this lower left.
SG
Hi SG,
This is exactly what I was looking for 🙂. Thanks.
I dint had a solution yet, and the screenshot I posted was from a tutorial I was looking at. I wanted to explain what I was looking for.
Thanks again.
Tornado diagram
