I want to have my chart, which displays a range of data that updates periodically, to represent the changes across sampled values in a more zoomed-in form by having the minimum value of the vertical axis match the minimum value in the dataset, and the maximum value accordingly.

I tried inputting a formula referring to the minimum and maximum found values, but it keeps returning that the input must be a number.

Is there any way to make it work like this? Thank you in advance.


I think the best thing you can do is enlarge your chart with the MAXIMIZE flag

maximize flag

  • That doesn't really do what I look for. It just enlarges the chart area to the entirety of the rectangle, but it doesn't zoom the range of values. Thank you for the suggestion, though.
    – TLSO
    Nov 16 at 11:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.