How to create a Line Chart to automatically include data from new rows entered in a sheet.
I'm trying to create Line Chart widget on a Dashboard, to automatically update itself as the rows are added into the source sheet.
How this was set up:
- In the original data sheet, the actual and expected performance of a parent level tasks are calculated based on formulas.
- Every week this task is copied over to another sheet via automation, just to show the performance for a particular week. This sheet is the source sheet of the chart.
- A chart is then built from the data in the source sheet.
The chart doesn't capture the data when new rows are automatically added to the sheet. How to fix this ?
Images attached for reference.