Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram show blank as zero value when based on a formula
When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart
will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram show blank as zero value when based on a formula
I found the reply myself in a question from another user similar to this issue.
I will use NA() instead of "" Thank you that works! "Data_Lisa" wrote: When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram show blank as zero value when based on a formula
"Data_Lisa" wrote in message
... When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. Replace the blank "" by NA() -- David Biddulph |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram show blank as zero value when based on a formula
Yes, but I can't have the line to leave gaps. It plots the line as if I have
interpolated chosed even if my Active chart have "Not plotted (leave gaps) chosed in Tools Options... Do you know why? "David Biddulph" wrote: "Data_Lisa" wrote in message ... When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. Replace the blank "" by NA() -- David Biddulph |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram show blank as zero value when based on a formula
Hi,
Hopefully this will shed some light. http://www.andypope.info/charts/brokenlines.htm Cheers Andy Data_Lisa wrote: Yes, but I can't have the line to leave gaps. It plots the line as if I have interpolated chosed even if my Active chart have "Not plotted (leave gaps) chosed in Tools Options... Do you know why? "David Biddulph" wrote: "Data_Lisa" wrote in message ... When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. Replace the blank "" by NA() -- David Biddulph -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagram show blank as zero value when based on a formula
Thanks, Andy
Lisa "Andy Pope" wrote: Hi, Hopefully this will shed some light. http://www.andypope.info/charts/brokenlines.htm Cheers Andy Data_Lisa wrote: Yes, but I can't have the line to leave gaps. It plots the line as if I have interpolated chosed even if my Active chart have "Not plotted (leave gaps) chosed in Tools Options... Do you know why? "David Biddulph" wrote: "Data_Lisa" wrote in message ... When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty cell interpolated. Yes, I know Excel say empty cell and the cell is not empty when there is a formula. Is there anybody who have found a "work around"? I often have formulas that generate zero in the result but I want to plot the result as if it was empty. Replace the blank "" by NA() -- David Biddulph -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
How do you nest the following formula to show blank cells | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |