View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default how to prevent zero error message for logarithmic plots

Simply do a find (Ctrl+F)
Look for "0"
Under options, look at values, and match entire cell contents.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jlrosner" wrote:

Somewhere in a very large file, there is a zero placed in a logarithmic plot.
Everytime I use the file I get the repeated error message that this problem
exists. Unless Excel can show me where in this 35000 line sheet the problem
exists, I dont want to repeatedly get this message. It effectively prevents
me from using the file.