Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Don't won't charts to display Zeroes
In the worksheets, I can easliy turn off display of zero values. In the
charts, I cannot find i similar option. When formulas return a 0, N/A or empty cell (""), the chart seems to handle it as a 0. I do not want to display those data points at all. How do I do it? |
#2
|
|||
|
|||
Have your formula return NA() and the "zero" value won't be displayed.
"metro" wrote in message ... In the worksheets, I can easliy turn off display of zero values. In the charts, I cannot find i similar option. When formulas return a 0, N/A or empty cell (""), the chart seems to handle it as a 0. I do not want to display those data points at all. How do I do it? |
#3
|
|||
|
|||
You can have the formula return NA(), which produces the #N/A error.
This is ignored by many charts, so that a line or scatter chart series (for example) simply interpolate the connecting line across the gap. A few chart types treat NA() as a zero, for example, area charts. A formula returning "N/A" is not the same as using NA() to produce the #N/A error. Any text returned in a cell is treated as the numerical equivalent of zero. "" is not an empty cell, by the way; it's a short text string, and is therefore treated as zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ metro wrote: In the worksheets, I can easliy turn off display of zero values. In the charts, I cannot find i similar option. When formulas return a 0, N/A or empty cell (""), the chart seems to handle it as a 0. I do not want to display those data points at all. How do I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |