LibreOffice 3.4.5 - how to auto update a chart
I have a spreadsheet (containing several sheets) originally created in Open Office some years ago. Of course when CentOS changed to LibreOffice it automatically converted itself. I have noticed one anomaly and am wondering if someone can offer me a workaround?
The first sheet contains daily investment data - daily closing values.
The second sheet contains, by reference, the data from each Friday - the week end closing values.
The third sheet contains a line chart of the Friday values from the second sheet.
Prior to conversion to LibreOffice I would observe that upon entering the Friday data on the first sheet, the data would be reflected on the second sheet and the chart updated to show the most recent week end data. Now that does not happen. I have to open the chart for editing of the data ranges (don't have to change anything) close the editing and now the chart will reflect the current data.
Any ideas how to make the chart automatically update when new data is input? Or a way to refresh the chart without having to poke and prod it?