Based on your subject line "smooth graph line", here is another option.
Use #N/A in place of your missing data.
Right click the line in your graph, and select "Format Data Series"
Select the "Patterns" tab, and check "Smoothed line"

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"Patience" wrote in message
...
I am using Office 2003 (Excel) to create a line graph representing daily
ranking. However, there are several dates for which values are not
available.
Is it possible to have Excel put a flat line in place of the missing
values,
connecting only the available data?

Thanks,