An alternative to bj's suggestion would be to use array formulas with a
secondary chart reference to eliminate the zero values. This site shows how
and provides a workbook that can be downloaded.

http://www.pdbook.com/index.php/exce...o_zero_values/

--
Regards,
John Mansfield
http://www.pdbook.com


"Caroltchr" wrote:

I have a worksheet that charts weekly values. I put these values into
a chart, which is regularly updated as I change the weekly values. I
don't want any zerio values to be charted. Is there any way for me to
have the chart only display the 0 values and display NO COLUMN if the
value was zero? thanks.