If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can an empty cell equate to non-plot point rather than zero?
if(cell="","",cellvalue)
Here, if logic determines that a cell is empty, the cell will be empty but the plot will show zero for the cell. if(cell="",na(),cellvalue) Here, if logic determines an empty cell the cell will be shown as #n/a, but the point will be a non-plot. How can one statement cause an empty cell but show as non-plot? |
#2
|
|||
|
|||
how can an empty cell equate to non-plot point rather than zero?
Hi,
The answer is because Microsoft programmed it that way. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "tomj" wrote: if(cell="","",cellvalue) Here, if logic determines that a cell is empty, the cell will be empty but the plot will show zero for the cell. if(cell="",na(),cellvalue) Here, if logic determines an empty cell the cell will be shown as #n/a, but the point will be a non-plot. How can one statement cause an empty cell but show as non-plot? |
#3
|
|||
|
|||
how can an empty cell equate to non-plot point rather than zero?
Shane thought you were wondering "Why?" for which his answer is accurate.
If you were wondering how to make the cell look empty but plot like it contains #N/A, you have to keep the #N/A in the cell, and use conditional formatting to hide it. However, this is a kludge, and it is worse if you need to make some calculation based on the cell. In this case you should set aside multiple data ranges, all linked to the original. For the chart source data range, show the #N/As. For the display range, show "". For the calculation intermediary, use whatever provides proper calculated values. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "tomj" wrote in message ... if(cell="","",cellvalue) Here, if logic determines that a cell is empty, the cell will be empty but the plot will show zero for the cell. if(cell="",na(),cellvalue) Here, if logic determines an empty cell the cell will be shown as #n/a, but the point will be a non-plot. How can one statement cause an empty cell but show as non-plot? |
Thread Tools | |
Display Modes | |
|
|