Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change line in Chart | Charts and Charting in Excel | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions |