ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   dredded Negative or zero values dialog box (https://www.excelbanter.com/excel-programming/370248-re-dredded-negative-zero-values-dialog-box.html)

NickHK

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





All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com