Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Excel 2003 file that is giving me the following error message when
I open it, or click on one of the graphs in the file: €śNegative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic scale. To correct the problem, do one of the following:€ť Of the two suggestions listed to fix this problem, one is not an option (do not use -0 amounts), and the other does not work (clearing the Logarithmic scale checkbox). Can I use the €śApplication.DisplayAlerts = False€ť command when opening the file in order to prevent the error from shoeing? If so, where would I use it or where would I insert it? Im not educated in creating code or extensive macro work. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Formula displays error message | Excel Discussion (Misc queries) | |||
how to prevent zero error message for logarithmic plots | Charts and Charting in Excel | |||
How to prevent error message during macro | Excel Programming | |||
How to write a formula that will prevent appearance ERROR MESSAGE | Excel Worksheet Functions | |||
Prevent Error Message | Excel Programming |