RE: How do I convert functions that are zero into a null ?
- From: "Nick" <Nick@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 15:02:04 -0700
Once again, thanks for your fast and accurate answer
In regards to my reply about the ISNA() function, please ignore ... I was
using the incorrect syntax.
Best Regards,
Nick
"Peo Sjoblom" wrote:
> To get the equivalent of a null value in a chart you can use
>
> =IF(cell=0,NA(),cell)
>
>
>
> Regards,
>
> Peo Sjoblom
>
> "Nick" wrote:
>
> > I have a sales worksheet that totals monthly from January thru December.
> >
> > I plot the summary sales by month in a simple line chart.
> >
> > The problem is that since the year is not completed, the line chart drops
> > off to zero for the month that total zero which makes it look like a sales
> > decline. I would like to make it just stop plotting at the last month with
> > sales.
> >
> > I can do this manually by deleting the totals for each month but I would
> > prefer to use some kind of an "IF" statement and a "NULL" value but am unable
> > to find the correct mix.
> >
> > Any ideas ? Thanks In advance. Nick.
.
- References:
- RE: How do I convert functions that are zero into a null ?
- From: Peo Sjoblom
- RE: How do I convert functions that are zero into a null ?
- Prev by Date: RE: How do I convert functions that are zero into a null ?
- Next by Date: Re: what do you use to enhance financial data?
- Previous by thread: RE: How do I convert functions that are zero into a null ?
- Next by thread: Re: How do I convert functions that are zero into a null ?
- Index(es):
Relevant Pages
|
