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!

Rather than changing the Index# values to #N/A to make your horizontal scale dynamic, change the Date values to #N/A instead.

I used a dropdown box to select the start date of the chart in my attached, suggested solution. There are other methods to make the chart horizontal scale dynamic. Many tutorials use the OFFSET function, and I've frequently used INDEX+MATCH to achieve a dynamic horizontal scale.