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
 
K

K Dales

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

Doughnut Chart linked with the slicer in the pivot table 0
Cannot see and gantt charts or other displays 0
How to disable error msg "zero values cannot be plotted on log cha 0
error message for phantom chart with log scale 1
Excel 2010. How to copy chart format to all charts in sheet 2
Turn off Excel alert 1
Delete chart series 2
dredded Negative or zero values dialog box 1

Top