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