my chart disappear when I try to update my x-axis min and max scale

[daniboymu]

I have a problem with my chart, when I update the period of the chart and updates the mininum and maximun X-axis scale my chart disappear, what can i do about that?
IF SOMEONE COULD FIX THE CODE PLEASE!

Sub ESCALADA()

Dim name As String
  
Application.ScreenUpdating = False
  
ActiveSheet.ChartObjects("Gráfico 5").Activate
ActiveChart.Axes(xlCategory, 1).Select
    
With ActiveChart.Axes(xlCategory, 1)
'.Crosses = xlMinimum
.CategoryType = xlTimeScale
.MajorUnit = Range("J7").Value
'.BaseUnitIsAuto = True
.MinimumScale = Range("H7").Value
.MaximumScale = Range("I7").Value
.TickLabels.Orientation = 45
.ReversePlotOrder = True
Application.ScreenUpdating = True
End With
End Sub

 

[sijpie]

Have a look at this thread:

Chart - call to MinimumScale function makes the plot disappear

Hello everyone, I am curently trying to create a chart with VBA and I am facing some dificulties trying to figure out how to adjust my X-axis. I use dates on this axis and if I do'nt set its the min and max dates programatically, the plot just goes from 01/01/1900 to 19/02/1900. The thing is...

www.mrexcel.com