![]() |
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