Avoid Column to scale Y-Axis?

Hi,

i’m currently building a grafana time series graph, and have the following (generic) issue:

  • Data can range up to 32.000 rarely
  • 98% of time it’s in the range of about 0 - 2000

Two data columns indicate a upper and lower limit, for example set to 30.000 and -30.000. These are applicable 24/7 and visualized by dotted lines.

Now, the issue i’m facing is, that these lines cause a permant scale of the graph, so it contains data between -30.000 and 30.000 all the time, making everything happening in the range of 0-2000 almost invisible.

Using logarithmic scaling is not an option, the data has linear character, which should be preserved, when looking at.

So, I wonder if there is a way to say: “Exclude the Columns X and Y from auto-scaling the Y-Axis. Show them, if other data makes this value become visible, else they are out of the diagrams rendering area”?