to stop zero from showing on graph

I have graphs for which values will be filled in time, but befor it's filled
I want zeroes not to be visible. Is it posible?

Hi,

Either leave the cells empty or use =NA()

Cheers
Andy

natash@ wrote:
> I have graphs for which values will be filled in time, but befor it's filled
> I want zeroes not to be visible. Is it posible?

--

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

I didn't write the original post but am having the same problem. This works
if I remove all content from the cell - however - I would like to have a
formula in the cell so that it automatically populates with data from another
cell in the worksheet - when that cell has data entered - so is there a
formula that will enable me to capture the data from another cell after it is
entered but still make the cell appear to be empty until then? Otherwise it
puts all zeroes in the graph until data is entered.

Thanks for your help.

Kathie Meier

"Andy Pope" wrote:

> Hi,
>
> Either leave the cells empty or use =NA()
>
> Cheers
> Andy
>
> natash@ wrote:
> > I have graphs for which values will be filled in time, but befor it's filled
> > I want zeroes not to be visible. Is it posible?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

Hi,

You need to include a IF condition in you formula.

=IF(X1<>"",X1,NA())

So if the other cell, in this case X1, has a value use it otherwise use
the NA()

Cheers
Andy

Brrnese wrote:
> I didn't write the original post but am having the same problem. This works
> if I remove all content from the cell - however - I would like to have a
> formula in the cell so that it automatically populates with data from another
> cell in the worksheet - when that cell has data entered - so is there a
> formula that will enable me to capture the data from another cell after it is
> entered but still make the cell appear to be empty until then? Otherwise it
> puts all zeroes in the graph until data is entered.
>
> Thanks for your help.
>
> Kathie Meier
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>Either leave the cells empty or use =NA()
>>
>>Cheers
>>Andy
>>
>>natash@ wrote:
>>
>>>I have graphs for which values will be filled in time, but befor it's filled
>>>I want zeroes not to be visible. Is it posible?
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

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

It works, gratefully natash@

"Andy Pope" wrote:

> Hi,
>
> You need to include a IF condition in you formula.
>
> =IF(X1<>"",X1,NA())
>
> So if the other cell, in this case X1, has a value use it otherwise use
> the NA()
>
> Cheers
> Andy
>
> Brrnese wrote:
> > I didn't write the original post but am having the same problem. This works
> > if I remove all content from the cell - however - I would like to have a
> > formula in the cell so that it automatically populates with data from another
> > cell in the worksheet - when that cell has data entered - so is there a
> > formula that will enable me to capture the data from another cell after it is
> > entered but still make the cell appear to be empty until then? Otherwise it
> > puts all zeroes in the graph until data is entered.
> >
> > Thanks for your help.
> >
> > Kathie Meier
> >
> > "Andy Pope" wrote:
> >
> >
> >>Hi,
> >>
> >>Either leave the cells empty or use =NA()
> >>
> >>Cheers
> >>Andy
> >>
> >>natash@ wrote:
> >>
> >>>I have graphs for which values will be filled in time, but befor it's filled
> >>>I want zeroes not to be visible. Is it posible?
> >>
> >>--
> >>
> >>Andy Pope, Microsoft MVP - Excel
> >>http://www.andypope.info
> >>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>