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.
Google-sheets – Stop lines in GDocs chart overlapping/obscuring other lines
google sheets
Related Solutions
I suggest using the Horizontal axis label area;
What you need to do is a few steps:
- Insert to Chart then add your Data Series, as you normally would with a Single Axis chart.
- (Optional) Change chart type to Line. You can change it to anything else later. Line seems to be a safe bet for the later options to appear. Not sure if this step is by Google design...
- Right-click on the chart and select Series.
- Change Apply Series to whichever Data Series you want to move to the Second Axis.
- Change Axis to Right Axis.
- Now you can go back to Chart type to make it a scatter, or bar, or anything else - the program will remember the Axis assigned to the Data Series, regardless of whatever options may be available.
tldr; the Google Support answer is broken for a few chart types. Do your Axis assignments with Line charts, and change the Chart Type after.
Related Topic
- Google-sheets – Creating a chart with independently indexed series
- Google Sheets – Add Additional Lines to Line Chart
- Google-sheets – Alternate colored lines in Google Sheets that respect other formattings
- Google Sheets – Chart with Steps of Constant Height Change, Variable Width
- Google-sheets – How to plot single intersecting point of 2 lines in Line Chart in Google Sheets
- Google Sheets – Not Processing Very Large Numbers
- Google-sheets – 1 plot with several lines with a common X axis but unique X and Y values… is this possible
Best Answer
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.