I have a X/Y graph ni CALC which has some values close to infinity. The region of interest though is only a small part, but depends on the parameters of the calculation, so setting the min and max as a fixed value is not an option. If I set the plot min and max to automatic it scales such that its non-descriptive.
I can calculate the region of interests upper and lower bounds. So for now I have set the plot ranges to automatic, and used MIN(outcome;caclulated-upperbound) and MAX(outcome;calculated-lowerbound), to limited the bounds, but this gives a disputable plot at best.
Is there a way to modify the min and max values of a plot based on the outcome of a calculation?
I use LibreOffice 184.108.40.206 for Windows x64