Hi All!
In my job I need to create a (tornado) plot, and I need to scale my x-axis depending on how much uncertainty I have. The problem is that I create my plots first, and then I do a simulation, and then I want the scale of the x axis on the varying number of plots to update itself by a number I have stored in a cell. How can this be achieved?
I have tried:
With ActiveChart.Axes(xlValue, xlPrimary)
.MaximumScale = 1.1 + Sheets(sheetin1).Range("BZ" & startcell1).Value
.MinimumScale = 0.9 - Sheets(sheetin1).Range("BZ" & startcell1).Value
End With
But the axis wont update after the plot is made and the cell is changed?
Also I think the changesheet command thing wouldn't help in my case because there can be several sheets with plots.
Best
Eirik
Bookmarks