Ask Your Question

How can I make a chart stay visible while scrolling?

asked 2017-06-12 16:25:03 +0200

mickspoors gravatar image

In Calc, is there a way to have a chart "float" in front of the cells, so that it is always visible when scrolling through the data?

I already have header rows locked, and I tried to anchor the chart to one of those cells but it didn't work.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-06-14 13:12:59 +0200

erAck gravatar image

Split the window below the chart, ie. select a row and menu View -> Split Window, then scroll in the lower view area.

edit flag offensive delete link more


Thanks erAck. Yes that's what I decided to do. Not exactly a perfect solution, but it works well enough.

mickspoors gravatar imagemickspoors ( 2017-06-16 16:16:49 +0200 )edit

answered 2017-06-14 14:26:52 +0200

pierre-yves samyn gravatar image


The solution that offers the most flexibility for resizing the window is WindowNew Window.

Otherwise, there is a macro for this on a French-speaking forum. It is necessary:

  • to allow the macros to be executed,
  • to adapt names (chart & sheet) at the beginning of the program.


edit flag offensive delete link more


Thanks Pierre

mickspoors gravatar imagemickspoors ( 2017-06-16 16:11:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-12 16:25:03 +0200

Seen: 306 times

Last updated: Jun 14 '17