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

N

norco

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
 
J

Jon Peltier

.... 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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use text descriptors as Y axis units 1
Make Y-axis values correspond to x- axis value 1
Chart with differing x axis 1
Chart x axis problem 1
the date value of series is incorrectly displayed 0
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
How do I specify X,Y axis and Series values in a line graph? 5
exporting data from a graph 0

Top