Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need to change anything.)

But sometimes there are three or more successive data points which are essentially collinear and so the middle points are obscured. I'd like to have the points themselves marked on the chart with dots maybe twice line's thickness so they stand out.

Is there a way to do this? I've tried looking through all the advanced settings and changing the chart type but no luck so far.

share|improve this question
If it helps, here's my chart: goo.gl/gzWEo – Charles Jul 14 '13 at 20:38
Is this any interest to you - if only to clarify your requirement? – pnuts Apr 12 '14 at 0:03
@pnuts: Yes -- actually that gave me a solution, adding markers to the chart. (Feel free to post.) – Charles Apr 12 '14 at 12:31
up vote 1 down vote accepted

Copy of a more extreme example of 'co-linearity`:

WA46640 example

seems to have pointed to an acceptable solution/workaround. That is, add data point markers (Point size, in Customise in Chart Editor) - in the image to one [red] data series (also with the line made thinner than the default and the other [blue] series line increased in width).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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