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
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
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
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
>
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)
Bookmarks