how to get rid of "Negative or zero values on log plot"

[alex22]

Hi, guys,

Do you know how to get rid of those "Negative or zero values cannot b
plotted correctly on log charts" messages without changing the data an
keeping log scale?? I work with a lot of numbers and can't affor
removing zeros.

Thanks!
Ale

 

[Rasputin99]

in a separate column enter the formula=if(targetcell<=0,"",targetcell). then
graph the cata in the new column. By entering a null space, the graph
ingores the cell.

 

[h1]

replace the formulas where you get unwanted zero or negative vallues
with
IF(your old formula;<=0;"";your old formula)

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **