disabling error messages

[Kaye]

I use a lot of logarithm charts on large data sets, many of which have
some zero or negative values. I don't need or want to plot those
values. And duh, of course they can't be plotted. Is there some way to
stop excel from continuously telling me it can't plot these values,
i.e. to disable the error message?

grateful for any suggestions... -Kaye

 

[Jim Gordon MVP]

Hi Kaye,

Give this a try..

Take a look at the Excel Preferences. Click on the Error Checking tab.
Uncheck anything you don't want to be flagged as an error.

-Jim Gordon
Mac MVP