Ignore zero or null cells values in a chart

[paulabeer]

HELP!! I'm trying to create a line chart for 12 months that doesn't plot zero (or null) values.

each of the 12 cells must contain a formula.

The option to 'plot empty cells as not plotted' only works when the cell contains no formula.

Any ideas??

[Ivan F Moala]

On 2002-05-20 23:26, paulabeer wrote:
HELP!! I'm trying to create a line chart for 12 months that doesn't plot zero (or null) values.

each of the 12 cells must contain a formula.

The option to 'plot empty cells as not plotted' only works when the cell contains no formula.

Any ideas??

Graphs won't plot #N/A...try putting these
in via your formula intead of 0 or Null ""