CrossesAt VBA Run-time error

[prk2022]

Can someone let me know why this is giving an error at .Axes(xlValue).CrossesAt = 0?


Sub Macro2()
ActiveSheet.ChartObjects("Chart 1").Activate
With ActiveChart
.Axes(xlValue).CrossesAt = 0
.Axes(xlCategory).CrossesAt = 0
End With
End Sub


Thanks

 

[Leith Ross]

Hello prk2022,

According to the VBA Help Files...

Excel Developer Reference

Axis.CrossesAt Property

<tbody>
</tbody>

Returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis. Read/write Double.