Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative values turn into zero values | Excel Discussion (Misc queries) | |||
Update Values Dialog | Excel Programming | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions |