I have a line chart as the picture below. The max and min values in my data are 410 and 290 for the peakflow series (the chart's visible range is something like 0 and 500 which is a bit pointless as there is no data below 290 or above 410). There are no zero values but there are empty values in the peakflow data.

Is there a way to define the chart's max and min values for the peakflow (left) vertical series?

enter image description here

2 Answers 2


You can define the chart's max and min values for the peakflow (left) vertical series by editing your chart:

  • Chart > Edit the chart > Customize > Vertical axis

enter image description here

Keep in mind:
This action will change the look of your chart.
The look also depends on your second values (Inhalor). Check or uncheck the Allow bounds to hide data for different results.

(If you still have issues please share a test sheet.)

  • did I really miss that? I looked and looked. Thank you!
    – atreeon
    Dec 22, 2019 at 9:39
  • 3
    "did I really miss that?" Too much caffeine. :) Dec 22, 2019 at 9:46

Workaround for when the Min and Max fields do not appear:

It seems Google Sheets hides the Min and Max fields if the values are formatted as dates, date times, durations, or currencies. Here is the workaround:

  1. First, format all the relevant cells as plain numbers by clicking Format, Number, Number.
  2. Then, right-click on the chart and click "Edit chart". Then click "Customise".
  3. Under vertical axis or horizontal axis, you should find the Min and Max fields:


  1. Now, if you want to return to the original formatting of the cells, you can. The minimum and maximum values will continue to apply.
  • Always incredible how stupid things developers can do when they try to be smart think what a user wants, even supposed to be awesome devs at Google...
    – kap
    Apr 7 at 21:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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