Charts

J

John

I have created numerous bar chart with VBA using data imported from SQL, the
charts are on a log scale. As log scales won't allow zero values, I get
the following error when going to view the chart:

Negative or zero values can not be plotted correctly on log chart......

Can I turn off the above warning, I tried application.setwarnings=False but
this was to no avail, can anyone advise ?

Also can any advise how to turn the coners of the chart to curves ?

Regards

John
 
G

Guest

If you are getting the warning, I assume it is because you have some values
that are zero or negative, so you have (in essence) an error condition. The
way to get rid of the message is to fix the data so there are no
zero/negative values. If the zero/negatives are valid data points, then (of
necessity) a log scale is inappropriate for the data.
 

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
Turn off Excel alert 1
Finding the Y-Value of Points 6
Why do charts disappear? 2
is it possible to create a time-scale using charts? 1
Formatting Y axis values based on other chart 2
Print problems w/ charts excel 2003/2007 3

Top