1) replace the missing values with =NA()
or
2) select chart; open Tools|Charts and adjust the setting for "Plot empty
cells"
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address
"ediamond" wrote in message
...
How do you create a chart in Excel that ignores missing values and come
out
with a chart that has connected lines as if the values were there?