prevent display of data series dropping to graph x axis for null d
Use NA() instead of "".
Jerry
norco wrote:
In a graph, I want to prevent the data series from going to the x axis if
there is null data in the cell. I am using a formula =if(cell value =
"","",average(cell range)) and this is what I am trying to suppress
|