View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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