Force continuous lines on a chart

[DataMinerHome]

Is there a way to force continous lines on a chart in Access? So, for example, if I have series A and B, I can get a continuous line for series A, but I just get 3 dots for series B. I want those 3 dots to be connected by a line.
Data looks like this:

X A B
1 5 3
2 3
3 12 8
4 0
5 20 7

 

[apr pillai]

Don't leave any column cells with Null Value, see that they are all filled up with zeros. The dots will be connected automatically.

 

[DataMinerHome]

But this will make the line go to zero, which is not what I want. In series B, I want a line going from 3 to 8 to 7, NOT 3 to 0 to 8 to 0 to 7.....???

 

[Aronvitki]

Since the value in a text box is of type Variant, use a space instead. If you need to make calculations, just use the IsNumber function on each cell.

 

[DataMinerHome]

I can't see that this makes any difference. Now I am back to getting just separate dots with no line in series b.

 

[DataMinerHome]

I figured it out. Replace blank fields with "#N/A" and the dots all get interpolated and connected. Works beautifully!