Prev: Crossing to New Year in Source Data
Next: Make a calandar chart
From: ymgagnon on 25 Jan 2010 14:40
When I'm getting a cell value of #N/A for my IF(VLOOKUP()) statement, it is
still plotting as 0:00. Is there a special number format I need to use in
order to not plot #N/A as zero?

"Jon Peltier" wrote:

> NA is just text. #N/A is the error that line and XY charts skip when
> plotting markers.
>
> - Jon
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> http://peltiertech.com/
>
>
>
> Barb Reinhardt wrote:
> > I'm using Excel 2007 and the line charts with NA are plotting as zero. I
> > suspect there's a setting I need to change, but I just can't find it. Can
> > someone assist?
> >
> > Thanks,
> > Barb Reinhardt
> .
>
 | 
Pages: 1
Prev: Crossing to New Year in Source Data
Next: Make a calandar chart