I have a Calc sheet containing a dozen rows of numbers. These are represented by a chart further down the same sheet.
I would like to hide the rows of numbers but when I do so, the chart also disappears. Is there a way around this?
Move the chart to a cell that is always visible, for example, in the data header.
or move the rows to an almost invisible area, like 9999