google sheetsgoogle-sheets-charts
Say I have a table like this:
| Date | Number |
| 0128 | 28800 |
| 0129 | 32500 |
| 0130 | 63410 |
| 0131 | 56400 |
| 0201 | 68700 |
| 0202 | 84060 |
And I can put a graph to show the data.
However, what if I add a new row to the end, I have to re-assign the range of the graph's data to make it redraw.
Is there any way that I can let the graph "know" that I have added a new row?
The range in the chart's Data - Select ranges box will expand automatically when new rows are inserted within the range, so one workaround would be to modify the code that writes the data on the spreadsheet to use sheet.insertRowBefore(sheet.getLastRow()) instead of sheet.appendRow()or similar.
Make sure you have an placeholder row after the last data row so that the inserts take place after the existing data but within the range defined for the chart.
You can use the method suggested by pnuts without combining the two tables. Enter both ranges, separated by commas:
Note that the ranges have 3 columns. One of them should have Y data in the 2nd column of the range, the other in the 3rd column of the range. This way, when the ranges are combined vertically by the chart, they reproduce the situation in pnuts' answer. The chart:
Best Answer
No, there isn't, unless you extend the range. All you need to do is include a bigger range then your data sits on. In your example, your dataset is on the range A1:B7. After you create a chart/graph from this range then click to edit this range and remove the last number so it would be A1:B and click on OK button. This way will chart/graph account for every newly added row in range calculated by chart/graph after you clicked on OK button.