Thread: Center y axis

I would like to center the y axis to 0 ([-1.7;1.7]), I tried to use Axes(xlCategory).CrossesAt but it gives me an error. For test, I used it on the x axis : Axes(xlValue) and it works.

For debug, I printed the value of Axes(xlCategory).CrossesAt when set at minimum, it shows 1, I dont understand why. (the minimum should be -1.7)

With Graph2
    .Activate
    .name = "Scatter result"
    .ChartType = xlLineMarkers
    .Axes(xlCategory).Crosses = xlMinimum
    .Axes(xlValue).Crosses = xlAxisCrossesAutomatic
    .SeriesCollection.NewSeries.XValues = Array(p1data)
    .SeriesCollection.NewSeries.Values = Array(p2data)
    .SeriesCollection(1).Format.Line.Visible = True
    .SeriesCollection(2).Format.Line.Visible = False
End With
MsgBox Graph2.Axes(xlCategory, 1).CrossesAt

Thank you for your help in advance

EDIT : I have finally found my mistake, I have created two different series with NewSeries ... sorry to pollute the forum...