I have a spreadsheet that I will continue to add data to, and have four dynamic charts linked to the data of the rows above.
PROBLEM:
Is there a way to pin these charts in place so that when I scroll left to right through the data, the charts stay visible?
CONSTRAINTS:
-Should be able to freeze first two columns
-Charts do not have to be below data, but should be visible at all times
-Charts should be on the same spreadsheet as the data
TRIALS:
I have tried to freeze panes and split screens at the same time with no success, it seems that one cancels the other out.
PROBLEM:
Is there a way to pin these charts in place so that when I scroll left to right through the data, the charts stay visible?
CONSTRAINTS:
-Should be able to freeze first two columns
-Charts do not have to be below data, but should be visible at all times
-Charts should be on the same spreadsheet as the data
TRIALS:
I have tried to freeze panes and split screens at the same time with no success, it seems that one cancels the other out.