How can I make a chart stay visible while scrolling?

[mickspoors]

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.

[erAck]

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

[mickspoors]

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

[PYS]

Hi

The solution that offers the most flexibility for resizing the window is Window▸New 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.

Regards

[mickspoors]

Thanks Pierre