I have set up graphs based on data tables that update with new data entry.
The data tables are updating properly but when I go back on the spreadsheet every few days random graphs are disappearing. These are annual and total count bargraphs so some update and some do not (ex. 2018 graphs are not getting new info). The graphs that disappear are random and have different properties each time. I am suspecting this is because I am saving in xlsx format and ods format would solve the issue. However, I need the spreadsheet in xlsx format.
Any advice?