Selective Display of Data on a Chart

[DanExcel]

Summary: Is there a way to make a chart not display "0" values?

Details: I have a chart that display all the data in a column. I want it to stop displaying at the row that has a zero in it. So, if my Y-values are in column D, and everything under D300 is 0, I want the chart only to display values upto the 300th row. I am willing to do this within "normal" excel or with visual basic.

Any suggestions? Please let me know if the question is unclear.

-DanExcel

 

[DanExcel]

I think I've managed to get around this with COUNTIF. I just use COUNTIF in the dynamic range -- the cells with #N/A are not counted.

Thank you for your help,

-DanE