Php Mysql Chart Help

[paolodecaro]

Good morning, I need to create a line graph that reads these fields from a Mysql DB: Date-time (X axis), Temperature in C° (Y axis). Can you suggest a valid example, keeping in mind that it must display 24 readings and the values X date-time axis must be placed vertically. Furthermore, the temperature range must be fixed from -10 to +50. Thanks for your help

[stockiNail]

@paolodecaro you have alreayd asked it if I am not wrong, here #11736 (comment)

For X scale you can use time axis, using the date library adapter you want. Other wise you can use a category one and you can see all the tick labels you want.

keeping in mind that it must display 24 readings

It depends on the data you are getting from backend. If the you have 24 samples is fine, otherwise you can reduce as you want to 24 data items to add to dataset.

the values X date-time axis must be placed vertically.

See other discussion: #11749

the temperature range must be fixed from -10 to +50

You should set min: -10 and max: 50 to Y scale where the temperature is reported.

Hopefully it helps.