Google-sheets – Statically positioned chart (ignore scroll)

google sheetsgoogle-sheets-charts

I have a Google Sheets document with four columns of data. I have a chart on the right side. When you scroll down to see all the data, the chart scrolls up off the screen.

Is there a way to make it static or float?

Best Answer

If the chart is fairly simple, you can use a sparkline() formula to recreate it in a cell that remains stationary in the frozen section of the sheet.

Use View > Freeze > [n] rows to insert a frozen section. To give the sparkline more space, use Format > Merge cells.

See the sparkline() help page.