# Stop the line when 0 is reached

1. ## Stop the line when 0 is reached

I have a chart ranging from Jan to Dec I have values up till Oct, I want the
line to stop there, is there any way I can stop the line from appearing after
the last value

2. ## Re: Stop the line when 0 is reached

Hi,

If the cells for Nov and Dec are really empty the line should stop.
If the cells contain formula then make use of NA() instead of ""

Cheers
Andy

Nigel wrote:
> I have a chart ranging from Jan to Dec I have values up till Oct, I want the
> line to stop there, is there any way I can stop the line from appearing after
> the last value

--

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

3. ## Re: Stop the line when 0 is reached

Thanks Andy

Not sure where I should use the NA(),

here is the formula for the field

=IF(VLOOKUP(\$W\$8,\$A\$31:\$Q\$291,O17,FALSE) =
0,NA(),VLOOKUP(\$W\$8,\$A\$31:\$Q\$291,O17,FALSE))

Is that where I woudl use the NA() statement? It still retains the 0

Nigel

"Andy Pope" wrote:

> Hi,
>
> If the cells for Nov and Dec are really empty the line should stop.
> If the cells contain formula then make use of NA() instead of ""
>
> Cheers
> Andy
>
> Nigel wrote:
> > I have a chart ranging from Jan to Dec I have values up till Oct, I want the
> > line to stop there, is there any way I can stop the line from appearing after
> > the last value

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

4. ## Re: Stop the line when 0 is reached

That looks like the sort of thing.

Are you saying the line still drops to zero when the data is zero?

Nigel wrote:
> Thanks Andy
>
> Not sure where I should use the NA(),
>
> here is the formula for the field
>
> =IF(VLOOKUP(\$W\$8,\$A\$31:\$Q\$291,O17,FALSE) =
> 0,NA(),VLOOKUP(\$W\$8,\$A\$31:\$Q\$291,O17,FALSE))
>
> Is that where I woudl use the NA() statement? It still retains the 0
>
> Nigel
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>If the cells for Nov and Dec are really empty the line should stop.
>>If the cells contain formula then make use of NA() instead of ""
>>
>>Cheers
>>Andy
>>
>>Nigel wrote:
>>
>>>I have a chart ranging from Jan to Dec I have values up till Oct, I want the
>>>line to stop there, is there any way I can stop the line from appearing after
>>>the last value

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

--

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1