I've looked high and low and can't seem to find an answer to what appears to be quite a straightforward issues (I would think).

I have a line chart where there is data at several points in a series but only only one set of points link up.

Does anyone know why this is? Is it to do with my data? If it is, I am struggling to see any relationships in the data that may explain this behavior.

Here is what I mean:

Messed up data points

As you can see, the red diamonds should be connecting - the same could be said about the blue squares and the dark blue triangles. Any thoughts?

Apologies if my colors are wrong - I'm colorblind.

Edit
Report