Wondering the easiest way to create 2x crossesat code, for datevalue now and a say 180 days time?
my crosses custom code didn't work,
Regards
Dinorx
- Code: Select all
Private Sub Chart_Activate()
ActiveChart.Axes(xlValue).Select
ActiveChart.Axes(xlValue).MinimumScale = DateValue(Now() - 1180)
ActiveChart.Axes(xlValue).MaximumScale = DateValue(Now() + 2000)
ActiveChart.Axes(xlValue).CrossesAt = DateValue(Now() + 0)
'ActiveChart.Axes(xlValue).CrossesCustom = DateValue(Now() + 180)
End Sub