Need to "not show" piece of line in graph
I am using a line graph with 2 sets of series.
Can someone please tell me how to stop the graph from showing values after a certain point in the series. If I use 0 or empty string ("") in the cells, the graph continues with the line just on the bottom of the graph. I need a condintional line as I have formual reffering to the "0". If that is possible. Many thanks -- Callan |
Use #N/A or equivalently NA() instead of 0 or text.
Jerry Callan wrote: I am using a line graph with 2 sets of series. Can someone please tell me how to stop the graph from showing values after a certain point in the series. If I use 0 or empty string ("") in the cells, the graph continues with the line just on the bottom of the graph. I need a condintional line as I have formual reffering to the "0". If that is possible. Many thanks |
Thanks, but where must I use it?
Here's the line I have in the cell =If(E60,E6,"") I tried to put the @N/A instead of (""). Doesn't work. If there is no value I need the cell to be empty so that the graph does not represent it on the line. Thanks -- Callan "Jerry W. Lewis" wrote: Use #N/A or equivalently NA() instead of 0 or text. Jerry Callan wrote: I am using a line graph with 2 sets of series. Can someone please tell me how to stop the graph from showing values after a certain point in the series. If I use 0 or empty string ("") in the cells, the graph continues with the line just on the bottom of the graph. I need a condintional line as I have formual reffering to the "0". If that is possible. Many thanks |
"Callan" wrote in message
... "Jerry W. Lewis" wrote: Callan wrote: I am using a line graph with 2 sets of series. Can someone please tell me how to stop the graph from showing values after a certain point in the series. If I use 0 or empty string ("") in the cells, the graph continues with the line just on the bottom of the graph. I need a condintional line as I have formual reffering to the "0". If that is possible. Use #N/A or equivalently NA() instead of 0 or text. Thanks, but where must I use it? Here's the line I have in the cell =If(E60,E6,"") I tried to put the @N/A instead of (""). Doesn't work. If there is no value I need the cell to be empty so that the graph does not represent it on the line. Don't use @N/A, use NA() -- David Biddulph |
Thanks alot! That was EXACTLY what I wanted. Thanks again!
-- Callan "David Biddulph" wrote: "Callan" wrote in message ... "Jerry W. Lewis" wrote: Callan wrote: I am using a line graph with 2 sets of series. Can someone please tell me how to stop the graph from showing values after a certain point in the series. If I use 0 or empty string ("") in the cells, the graph continues with the line just on the bottom of the graph. I need a condintional line as I have formual reffering to the "0". If that is possible. Use #N/A or equivalently NA() instead of 0 or text. Thanks, but where must I use it? Here's the line I have in the cell =If(E60,E6,"") I tried to put the @N/A instead of (""). Doesn't work. If there is no value I need the cell to be empty so that the graph does not represent it on the line. Don't use @N/A, use NA() -- David Biddulph |
Not @N/A, #N/A as in =IF(E60,E6,#N/A) or =IF(E60,E6,NA())
Jerry Callan wrote: Thanks, but where must I use it? Here's the line I have in the cell =If(E60,E6,"") I tried to put the @N/A instead of (""). Doesn't work. If there is no value I need the cell to be empty so that the graph does not represent it on the line. Thanks |
All times are GMT +1. The time now is 10:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com