Forum Discussion
Unwanted horizontal line
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?
Here it is. I have deleted all data, but you can see a sample of the offending lines.
For example there are 6 of them between A2..AA4 of varying lengths
There is one at lines 17/18 under and showing through the chart. There is a further one at L34..R35
I hope you get the file. BTW I have the same problem on other worksheets independent of this one.