Charts  
Author Message
UnLuckyStephen





PostPosted: Tue Nov 15 08:02:04 CST 2005 Top

Excel Programming >> 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

Excel365  
 
 
KDales





PostPosted: Tue Nov 15 08:02:04 CST 2005 Top

Excel Programming >> 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




> 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
>
>
>