Thread: negative/zero values on logarithmic plot warning
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero Ed Ferrero is offline
external usenet poster
  
Posts: 115
Default negative/zero values on logarithmic plot warning
Hi,

Try using a helper column with a formula like =IF(D6<=0,NA(),D6) and plot
that.
i.e. replace zero and negative values with #N/A

Ed Ferrero
www.edferrero.com


Reply With QuoteReply With Quote