dredded Negative or zero values dialog box
Why not check your data before making the chart:
=COUNTIF(DataRange,"<=0")
NickHK
"Damien" wrote in message
...
Hi all,
I need to be able to disable the following :
The dialog warning box that states - "Negative or zero values cannot be
plotted correctly on log charts. Only positive values can be interpreted
on a
logarithmic scale..........
I have tried:
Application.DisplayAlerts=False to no avail.
Is there a way of ridding this warning??
Thanks in advance D
|