log graph zero or negative values error

[Joyce]

Hi,

Excel gives an error message when you try to plot a zero
or negative number on a graph. I am using a template, so
I don't want to go through and manually remove the zero
data every time. Is there any way to turn off the error
message, it is getting VERY irritating.

Cheers,

Joyce

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Joyce.
Please use the newsgroup for further discussion.]

As far as I know, XL insists on complaining when one wants to plot
log(x) where x<=0, since that is no corresponding real mathematical
value.

You could modify the template to replace the zeros with empty cells or
if they are the result of a formulas, use NA() instead of 0 or "".

If you want to check past discussions on the subject, check the
google.com archives of the XL NGs. Something along the lines of
http://www.google.com/groups?as_q=log error%
20suppress&safe=off&ie=UTF-8&oe=UTF-8&as_ugroup=*excel*&lr=&num=20
&hl=en

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions