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