How can I keep a chart from scrolling out of view when scrolling down to see the data? In other words, freeze the chart in place while I scroll.
If you have both chart and data on same sheet, then you just freeze the rows just below chart (View → Freeze Cells) to keep the chart area always on-screen.
If I understand correctly, the bottom of the chart would have to be above the top row of data in order to scroll the data while the chart remains stationary. This is better than nothing, but I was hoping for a way to scroll the data up the side of the chart. This is what I’ve got now: https://postimg.org/image/rn1g1kved/
Well, another option would be Window → New Window