Forum Discussion
Unwanted horizontal line
I could be an object.
Try selecting it and hit the DEL-key.
The line is not selectable. It is a line looking the same as a border line and is positioned exactly on the gridline between two rows. It does not occupy any area. If I place the cursor in the column anywhere above or below the line and insert a column, the mystery line gets longer.
Most irritating is that it shows up as a horizontal line on a chart which is placed on top of it.
What happens if you remove the chart?
Nothing happens to the line because it is not attached to the chart, it is attached to the spreadsheet, so it stays there. I probably misled you by saying that when I copy the chart, the mystery line goes with it. This is true only because I am copying both the chart and the linked data in one go to another location, so I select all the cells, and then of course the mystery line is copied too. But it is not attached to the chart.
The chart masks out the gridlines but the chart does not mask out the mystery line. If I write "abc" in a cell and then put the chart on top of it, I don't see the "abc" of course. But I do see this stupid line.
I have no more ideas.
Could you upload your file?