Ask Your Question

How can I keep a chart from scrolling? [closed]

asked 2017-02-27 14:59:51 +0200

J Linux User gravatar image

updated 2020-10-12 16:25:57 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-21 13:54:31.305888


1 Answer

Sort by » oldest newest most voted

answered 2017-02-27 17:51:42 +0200

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.

edit flag offensive delete link more


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:

J Linux User gravatar imageJ Linux User ( 2017-02-27 19:31:47 +0200 )edit

Well, another option would be Window-> New Window

Mike Kaganski gravatar imageMike Kaganski ( 2017-02-27 20:08:50 +0200 )edit

Question Tools

1 follower


Asked: 2017-02-27 14:59:51 +0200

Seen: 3,477 times

Last updated: Feb 27 '17