| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
prevent display of data series dropping to graph x axis for null d
.... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| combination x-y scatter and column graph | Charts and Charting in Excel | |||
| graphing two series on x axis | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
