Charts
 

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

Charts
 

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.
--
- K Dales


"John" wrote:

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