Forum Discussion

SustainableWombat's avatar
SustainableWombat
Copper Contributor
Oct 27, 2020
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...
excel
Formulas and Functions
  • SustainableWombat's avatar
    SustainableWombat
    Copper Contributor
    Oct 27, 2020

    HansVogelaar 

    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?

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 27, 2020

      SustainableWombat 

      Like this:

       

      ActiveChart.Axes(xlValue).CrossesAt = Range("A1").Value

      • SustainableWombat's avatar
        SustainableWombat
        Copper Contributor
        Oct 27, 2020
        works like a charm! thanks!
        I shall invest some time on the side to learn vba too! cheers
    • SustainableWombat's avatar
      SustainableWombat
      Copper Contributor
      Oct 27, 2020
      Oyes, i decided to go with VBA and likely link it to a command button.

Resources