google sheets
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?
My understanding of your requirement is as below, though this does not apply your sample data:
The layout of the left four columns is required - in effect I have substituted:
10 100
30 110
60 150
80 180
for your sample data in the OP.
I selected the data area, Charts, Charts, Line and checked both Use row 1 as headers and Use column A as labels. This ended up with the appearance of a scatter plot but in Advanced edit..., Customise, Features this, oddly, was fixed by checking Plot null values.
The colours, datapoints etc were customised for the image.
Use "Advanced edit" option in the dropdown shown in upper right corner when the char is clicked. (It can also be accessed by right-clicking the chart.)
It will bring you back to the dialog you saw when inserting the chart. Change the data range on "Chart types" tab, and click "Update".
Best Answer
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 axisKeep in mind:
This action will change the look of your chart.
The look also depends on your second values (
Inhalor). Check or uncheck theAllow bounds to hide datafor different results.(If you still have issues please share a test sheet.)