Broken line when drawing date comparison chart with partially missing data

[shane2004]

Hi, I've tried to generate a comparison chart, the data is listed below, since those three rows in bold are partially missing data, so the chart rendered into the broken line. Is there any chance I can still generate the smooth lines?

Date Price1 Price2 

03 Aug 2007 1053 1052

10 Aug 2007 938 1052

17 Aug 2007 998 1037

24 Aug 2007 993 1049

31 Aug 2007 988 985

07 Sep 2007 988 994

14 Sep 2007 985 1000

21 Sep 2007 1013 1007

28 Sep 2007 1018 1007

05 Oct 2007 1015 1009

12 Oct 2007 1030 1009

19 Oct 2007 1053 1017

26 Oct 2007 1035 1015

01 Nov 2007   1044

02 Nov 2007 1043 

09 Nov 2007 1040 1060

16 Nov 2007 1025 1056

23 Nov 2007 1025 1068

30 Nov 2007 1000 1019

07 Dec 2007 960 1017

14 Dec 2007 910 1019

21 Dec 2007 955 998

04 Jan 2008 1030 1037

11 Jan 2008 1028 1029

18 Jan 2008 1055 1031

25 Jan 2008 1058 1032

01 Feb 2008 1115 1090

08 Feb 2008 1138 1068

15 Feb 2008 1208 1083

22 Feb 2008 1180 1092

29 Feb 2008 1193 1194

07 Mar 2008 1170 1209

14 Mar 2008 1175 1229

20 Mar 2008 1100 1231

28 Mar 2008 1175 1240

04 Apr 2008 1165 1168

11 Apr 2008 1168 1173

18 Apr 2008 1168 1168

25 Apr 2008 1175 1160

02 May 2008 1189 1174

09 May 2008 1268 

16 May 2008 1270 1186

23 May 2008 1340 1201

30 May 2008 1335 1335

06 Jun 2008 1270 1350

13 Jun 2008 1303 1318

20 Jun 2008 1255 1341

[Frank]

This is by design. Null values will produce breaks in the line.

If you want a continuous line, you need to leave all null values at the end of the series. Take a look at the following posting:

http://community.softwarefx.com/forums/p/20/40.aspx#40

It explains how your data needs to be reorganized so that there are no gaps.