Looking for some advice on using Charts. I have everything working well for my current data, but when something is added in Glide, it gets added to the last row of the spreadsheet. From what I can tell in Google Charts, the Data Range can’t be just “C:C” to get the full column C, for example, but rather has to be a set range (which can only include “valid” cells that already exist) like C1:C1000. Even if I add 1000 rows to my sheet, my Chart can only using C1:C1000 as the Data Range. When a new item is added in Glide, it gets added to the bottom of the sheet and creates row 1001, which means my Chart is now not updating based on new data.
Anyone experience this and have any advice?! Thank you