This is a follow-up question to Daily statistics
I’m using LibreOffice Calc 18.104.22.168 on MacOS Yosemite, all English.
I have a very simple data set: column A is a date-time (YYYY-MM-DD HH:MM:SS) and column B is a quantity (number). I have created a pivot table with date-time as a rowfield, average quantity as datafield, and grouped data by day. I have also created a line graph based on the pivot table output.
My data set has since grew: the pivot table was created using a data range of A1.B1:A100.B100, it now contains data up to A200.B200. I want two things:
- Update my pivot table to consider this new data range
- Update the graph to consider the updated pivot table data
I could obviously recreate both the pivot table and graph, but I would like this to be easier. Can this be done otherwise?