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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
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.
If you really need this AND you are not afraid by code, you can do it by editing CSS of your current page. Next refresh of your page, you will have to redo this
On Chrome :
leftproperties to the pixel values wanted (Click on each value and use arrows of your keyboard to adapt in live)