0's in Charts

[har21441]

If I have a cell that displays a 0 data (due to a formula in that cell) how can I get the chart to not adjust to the 0

I have a chart mapping use of a product dduring a fiscal year. We are looking at weekly totals. The weeks are formulated to total as data is input. The chart maps the data from left to right (line chart), but drops to zero and follows the zero line across the length of the chart. This zero line is what I would like to eliminate.

Thanks

[NBVC]

Try getting the formula to result in the #N/A error instead of 0.