How do I (if possible) get my charts to automatically update with new information that's been added to the sheet?
I currently have a sheet that has a scoring system based on a 0-100 percentage. When I created the chart I selected all the columns I wanted and included all 5 line entries. It charts just the way I want it to, however when someone uses the web form to enter new data, that new data is excluded from the chart and I have to manually edit the chart and select the new data.
Is there an option for the charts to automatically include new lines of data and update? Or does this have to be done manually everytime?