Forum Discussion
Unwanted horizontal line
My first impression: There are no lines.
I switched off the gridlines and deleted the chart.
My second impression: There are no lines.
I pressed F5, clicked "Special..." and selected "Objects".
My third impression: Suddenly there seem to be some lines. But they have a heigth of 0 cm. That's why you couldn't select them with the mouse.
Keep them selected and press DEL.
Thank you for your patience. Perhaps you do not see the lines because of software differences. I am using Excel 2003, normally an excellent product with no other problems!
Therefore I send you the attached screenshot in a Word file as a object and you cannot fail to see the lines with varying length and also the most peculiar one between lines 17 and 18 which is both on the worksheet and on top of the chart.
On my HP, pressing the F5 key only causes an exit from the worksheet. Please explain how I can select the line without using F5 and without using the mouse.
If it was a table you removed filters & some formatting from, try Click Table Design, then Convert to Range to remove Table
Yes, you're right. But probably you know that once a normal private user has bought Office 2003, there isn't much incentive to buy a newer version and then have to learn all the new icons and menus.
The only way round this problem for Microsoft is to withdraw the old product, plus convince the big users to upgrade. The same applies to Windows. W-10 was offered free, but I didn't take the offer.
However, MS will get me in the end! That's alright. It's the problem that software doesn't wear out. For some customers you have to wait till their hardware wears out.
Thanks, yes of course, I must have been too light on the control key. Problem solved, many thanks.
Sorry for jumping in with off-topic
"Excel 2003, normally an excellent product with no other problems!"
Agree, Excel in general is quite excellent product. However, Excel 2003 is not supported for about 7 years, and even if it has no other problems it doesn't have a lot of other possibilities compare to latest versions.
But John, that's your business, just a comment.
John F. Davies wrote:Is there a way to deselect the charts so that I don't have to move them to and fro?
It's like any other mutliple selection: Hold the CTRL-key and click on the chart. It should be de-selected.
Thanks, it works. With Control-G, Special, Objects, all the unwanted lines are selected, which I can then delete in one go. Since all the charts are also selected, I first had to copy them to another sheet, and then after the deletion of the lines, I copied them back again. Is there a way to deselect the charts so that I don't have to move them to and fro?
Huh... try CTRL-G then.
