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

A

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
 
R

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.
 

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

setting negative values to zero in a column 4
negative/zero values on logarithmic plot warning 4
dredded Negative or zero values dialog box 1
Negative or zero values cannot be plotted correctly on log charts 6
DIsplaying negative time values 1
Error bars plot black triangles 6
Zero values in a log chart 1
Excel should STOP the "zero or negative ..in log plot" error msg 1

Top