Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
"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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge document with a line graph | Charts and Charting in Excel | |||
Scatter plot and line graph combination | Charts and Charting in Excel | |||
Making a bar and a line graph together | Excel Worksheet Functions | |||
Colour part of a line on an X Y graph | Charts and Charting in Excel | |||
Is there a program in office to create a line graph? | Excel Discussion (Misc queries) |