Thread: prevent display of data series dropping to graph x axis for null d

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

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

.... for the second instance in the formula:

=if(cell value="",NA(),average(cell range))

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
news:43A94843.2090704@no_e-mail.com...
> 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
>