Hi All,
I have a problem on my spreadsheet, i logging temperature and humidity data to Google Spreadsheet, it's works and running good, then i try to poit a chart, Due to the data is keeping updating every minute, the chart is work perfectly on showing temperature against to time, but after a coupling of hours, the chart stop to update, i found that the chart update stopped when some data was losed, ever though the new data was input again, Do you have any solution, Thanks!
The dynamically updating function was stopped as following condition.
| 15/06/2016 17:15:04 | 3197.89 | 57.71 | 3363.92 | 29 | 28.5 | 89.1 |
| 15/06/2016 17:16:04 | 3169.39 | 57.2 | 3330.97 | 29.06 | 28.5 | 89.1 |
| 15/06/2016 17:17:03 | 3138.04 | 56.64 | 3299.89 | 29 | 28.5 | 89 |
| 15/06/2016 17:18:03 | 3115.24 | 56.18 | 3272.2 | 29 | 28.5 | 88.9 |
| | | | | | |
| | | | | | |
| | | | | | |
| 15/06/2016 17:32:03 | 2730.49 | 49.35 | 2878.97 | 28.81 | 28.5 | 89.2 |
| 15/06/2016 17:35:03 | 2625.04 | 47.46 | 2766.94 | 28.88 | 28.4 | 89.3 |
| 15/06/2016 17:37:03 | 2536.69 | 45.88 | 2682.31 | 28.88 | 28.5 | 89.3 |