How to control Y-axis value?

I cannot control Y-axis value of chart with Worksheet.ChartObjects("Chart 8").SeriesCollection(5).YValues = "=Sheet1!$A$4:$A$5", why....??
chart.jpg

Hi,

You need to read in the max and min values of your data series. Then use set your y upper and lower ranges to this values.

Add a bit either side to the max and min so the tip and bottom of the graph is not at the extreme top or bottom.

Originally Posted by techflutter

Hi,

You need to read in the max and min values of your data series. Then use set your y upper and lower ranges to this values.

Add a bit either side to the max and min so the tip and bottom of the graph is not at the extreme top or bottom.

In example case I had set max as range("A4")=100,000; min as range("A5")=-100, but not work for YValue due to error438, Can I any method to control Y-axis?