I had the same problem, I wanted to distribute my values on the category (x)
axis evenly despite missing value points. #N/A works fine, but becomes quite
clumsy if I want to print the whole work-sheet. I tried to hide the rows
containing #N/A-values, but then the wanted effect dissapears in the chart.
Is there another way to plot data on a linear x-scale in excel?

Best regards,
Sanna

"Dana DeLouis" wrote:

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,