Forum Discussion
Solved
Sensitivity Analysis: Tornado Chart - Looking to vary the base case and updating the chart
Hello All, I have plotted the tornado chart as follows: Base Case Margin = 75% This 75% base case is plotted as the "axis value" - as circled in red However, I am looking for a way to...
I don't think that is possible without using VBA code... 😞
I don't think that is possible without using VBA code... 😞
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.HasAxis(xlValue) = True
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.Axes(xlValue).Select
ActiveChart.Axes(xlValue).CrossesAt = 0.75
I am quite stuck on how i can link the "axis value" to a particular cell (eg. Cell A1), i currently type it as 0.75. How can i link it to a particular cell?
- works like a charm! thanks!
I shall invest some time on the side to learn vba too! cheers
- Oyes, i decided to go with VBA and likely link it to a command button.