Statically positioned chart (ignore scroll)

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?

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.

Attribution
Source : Link , Question Author : THE JOATMON , Answer Author : doubleunary

Leave a Comment