How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one.


  • Can you share that spreadsheet with us, so we can have a look?
    – Jacob Jan
    Commented Jan 2, 2013 at 8:27
  • Yes, part of the green series is the same as part of the yellow series. I'm not so keen on what you'd suggest - ideally I could make the lines dashed and interleaving.
    – tog22
    Commented Feb 18, 2014 at 13:21

1 Answer 1


I agree dashed would appear best in the circumstances but I'm afraid that does not seem to be an option. BTW I've only just seen your latest comment (no 'ping' to it).

With examples as below the top left chart shows the red line heavily obscuring the blue over the range where the example data is identical for both series - not good. The chart below that is with a small offset to the red series. I think a viable solution for the odd chart or two but I agree tedious for many charts (if they insist on overlapping!) as I added the offset manually.

So I offer an alternative which is on the right - increase the thickness of the blue line, reduce that of the red and add markers to it.

WA35937 example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.