Line chart with no connecting lines for missing Y data?

[Dmitry]

I'm using TeeChart Pro 7 VCL with D2005 and trying to figure out how to avoid connecting lines when there are gaps in the data charted on a line series chart. For example - consider this data:

X Y
5 1
10 2
15 3
20
25 4
30 5

If using Excel to plot this data no line will connect the Y values 3 & 4 at X values 15 & 25, because there is a missing Y value at X value 20. I can't duplicate this in TeeChart. I've tried editing the data but it doesn't allow an empty value for any Y that has a corresponding X.

Of course a scatter chart type works but then there are no connecting lines anywhere.

Any ideas if or how this can be done in TeeChart?

Thanks!
Alex

[Narcís]

Hi Alex,

You can do what I suggested to another client here.

[Dmitry]

Thanks for the quick response Narcís, unfortunately neither of your suggestions work.

The AddX method still draws the connecting line across the missing Y value and AddNullXY doesn't have the X value at all.

Any other ideas?

Don't tell me Excel charting does something that TeeChart can't!!!!

[Narcís]

Hi Alex,

Have you tried using AddNull as I said in the thread I pointed you?

Thanks in advance.