Thread: dont show zero vaules in a chart

I have a chart that is tracking sales for the month, (by day) the chart has
Zero values due to an "IF" statment that has a false or the reference cell is
not yet filled in resulting in a "zero value"
the chart has a trend line that is tending based on all the remaining zero
values .

I have changed the Chart options to not display zeros, but this doesnt solve
it.

Hi,

In your formula use the function NA() instead of False.

Cheers
Andy

Donald Watkins wrote:
> I have a chart that is tracking sales for the month, (by day) the chart has
> Zero values due to an "IF" statment that has a false or the reference cell is
> not yet filled in resulting in a "zero value"
> the chart has a trend line that is tending based on all the remaining zero
> values .
>
> I have changed the Chart options to not display zeros, but this doesnt solve
> it.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info