Hard to be sure from your description, but I suspect that you may be using the wrong graph plotting route. Make sure you are using X-Y.
Also, I can often save a lot of aggro if you copy ALL of your data into a couple of discrete columns off to the right somewhere, and plot from them. Then all Excel sees is numbers copied from another cell.
G