How to disable error msg "zero values cannot be plotted on log cha

J

Jiri Zacharias

I use data where zero and positive values are mixed and plot them on a chart
with a log scale where lower axis limit is set to 10.

When the chart is for the first time activated an error message "Negative or
zero values cannot be plotted on log charts ..." appears. Next times it OK,
without message, until the chart is redrawn.

How can I disable this error message (Excell Error ID 196677) via VBA or API
code implanted in VBA?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error message for phantom chart with log scale 1
dredded Negative or zero values dialog box 1
Charts 1
logarithmic trendlines using zero values 2
Negative or zero values cannot be plotted correctly on log charts 6
Turn off Excel alert 1
how to avoid zero error in log log plot 1
Error bars plot black triangles 6

Top