Problem:
Sometimes… one view pane is not enough. Working with larger data sets and many columns – there seems to be no place to put the graphs – save for, logically, on a separate tab/sheet within our file. But switching back and forth between tabs hinders our ability to view the data graphs in real time as we update the data.
Solution:
Open the SAME file in multiple window. Both – LibreOffice Calc and Excel support this – on all platforms OSX, Windows, Linux (Excel via Wine – should work but not tested). All changes made to the “data” window, will be immediately displayed in the “graph” window. Works great for summaries, and other dashboard-style problems.
With the file open – select the Window menu and choose “New Window”
The SAME FILE will now be open TWICE – in separate windows. Just select a different TAB in one of them, and align per your needs.
This works exactly the same way with either LibreOfficeCalc (screen shots above) and with Excel (screen shots below).
