Select the chart
Choose ToolsOptions
On the Chart tab, for 'Plot empty cells as', select Interpolated
Click OK

Rob wrote:
I have dates in column A and a value in B. I want to create a line graph
showing values across ALL dates using the points I have actual dates for as
the end points for each line segment. How do I get Excel 2003 to do that?
Thanks!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html