0

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

1

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.)

| improve this answer | |
  • did I really miss that? I looked and looked. Thank you! – atreeon Dec 22 '19 at 9:39
  • 2
    "did I really miss that?" Too much caffeine. :) – marikamitsos Dec 22 '19 at 9:46

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.