Series/lines invisible on chart

Hi,

I have a spreadsheet with dates in column A.
Column B holds values corresponding to all the dates.

However column C holds values on a variety of dates, but not all of them.
I am creating a line-chart with dates on X axis. On the Y axis I have created two series, one for the values in column B and one for the values in column C.

A line is created and is visible for coulumn B, but the line for coulumn C is not visible in my chart. I can find the C-line by tapping along the line I know is there, and move along it, but it is invisible.

I have tried to define the chart as category instead of time-scale, but the line does not want to reveal itself...

Someone who knows why this can be, or have any suggestions to what I change?

Gnoke

With the chart selected, choose Tools-Options, select the Chart tab, and make sure the option to interpolate blank cells is on.

Glad to help. Please don't forget to mark 'Solved'.