I have a 5-sheet 4Mb spreadsheet with many lines of data, from which I select one line with VLOOKUP functions to create a table that is used to drive a pair of charts to display the selected data. Select a new data line, the table changes and the charts should change.
This was working (and I’ve used the approach before on MS EXCEL quite happily).
Currently I can change the data and see the change in the data table, but the charts do not update - they are holding the previous charts’ data. No obvious reason for this lock-up. Any suggestions welcome.
Version: 126.96.36.199 Calc
Build ID: 3fd416d4c6db7d3204c17ce57a1d70f6e531ee21
running on Win7 but I don’t think this is an OS-specific issue.