Oct 27 2020 02:22 AM
Hello All,
I have plotted the tornado chart as follows:
However, I am looking for a way to automatically update this "axis value" should my base case changes.
Are there any other methods to plot this tornado chart so that it automatically updates when the base case changes?
Other Information:
Cheers!
Oct 27 2020 05:39 AM
SolutionI don't think that is possible without using VBA code... :(
Oct 27 2020 09:25 AM
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?
Oct 27 2020 09:26 AM
Oct 27 2020 09:43 AM
Oct 27 2020 09:51 AM
Oct 27 2020 05:39 AM
SolutionI don't think that is possible without using VBA code... :(