View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
I plot spectra I plot spectra is offline
external usenet poster
 
Posts: 1
Default negative/zero values on logarithmic plot warning

Hello all,

I realize that a negative or a zero plot on a logarithmic scale is
meaningless. However, many times I'm working with data that is full of noise
an non-ideal, i.e. it contains zeros and/or negative values. I still would
like to plot them on a logarithmic scale. Excel does this quite well and
ignores the negative/zero values on the chart. However, IT PRODUCES A
WARNING EVERYTIME I TOUCH THE CHART! I make tons and tons of these graphs,
so in order to save what little sanity I have remaining, I must find a way to
turn this warning off. Please help me.