Hi all,

I am trying to chart a series of data points from a table which looks up
values dependant on the contents of a seperate cell with a drop down list.
The table / chart is designed to be used until the end of the year, so
obviously values after today show as blank, (there are formulas already in
the table which will allow the graph to populate over time).

Is there a way of not charting cells with a blank value in Excel 2007 to
prevent the graph displaying these data points as zero?

Thanks in advance