How to get Excel to ignore blank or #N/A cells when plotting a line chart?

Hey guys,

I've been trying to figure this out for a while but I can't seem to plot a line graph without Excel including the cells that are either blank or labelled "#N/A". Since my goal with this was to make the chart dynamic and changing constantly over time, I wanted to allow the graph to only include the numbers plotted and nothing more (including the extra dates).

I've included a sample of what I'm working on right now. What I wanted to see was the graph at the bottom starting from 12/30/2005, not the 1998 date that I've specified earlier in the chart.

Thanks for all the help provided!