I’ve got a calc sheet of data with date columns. Each day the sheet grows with one row and I need to put the last 30 days data on a chart.
Since named ranges and functions as data source for charts are unsupported, I’m not quite sure how to achieve this.
I want to avoid manual deletion of rows, or modifying the graph data source field daily.
Is there a way to move rows that are older than 30 days (column A is ISO format date, like 2018-12-31) to a different sheet? I don’t want to copy them, I want to move them completely - I guess that way I can keep 30 days of data presented.
I never tried macro in excel/calc so not sure how to do it.
Or if named ranges can be achieved for charts, please do let me know.