Change scale Y axis

[SiebeD]

Hey there!

I make a graph but here i display sensor data, and sometimes the data is way of. I was wondering if it is possible to scale the Y axis of a graph in VBA code. Because I run the Query (that has the data for the graph) with vba code.
Here is de graph that i have and as you can see the range need to be way smaller so that i can't see the wrong data. (the name of hte graph is "GrafiekDebiet")

I know that you can just change the properties of the graph but in another form you can change the criteria for the graph. So I want to be able to scale the graph differently when needed in my VBA code.


Thanks!

[June7]

If you are using Modern Chart, my understanding is that cannot be managed programmatically. I have done it with classic MSGraph.

What do you mean by "wrong data"? If data is not desired then why is it produced in query?