I have date that includes subjective comments, but also dates and objective
data.
I'd like to have a chart that plots only the dates with data.
I can use autofilter to hide the rows with no objective data, but then I
can't see subjective comments. It seems to be a pain to have to activate
autofilter to view the graph, but then deactivate to see the whole data sheet.
Example below
Date # Units Weather
1/1/06 10 Sunny
1/15/06 12 Rainy
1/16/06 Sunny
1/20/06 3
1/22/06 Rainy
1/30/6 5 Snow

I'd like a graph that shows only the days with "# units" data available, but
want to view the above sheet otherwise.