Please help with excel chart ignoring text cells
Dear Jon,
Thank you for your answer.
I am using a macro to set maximum and minimum for "y axis" most probably the one you have shared :)
When i convert to NA, my minimum, maximum which based of a calculation gives NA and macro stops working.
Do you have an alternative solution.
as it is not number, my calculation already ignores the texts, and gives what i want excep the data trend line. Data trend line goes out of the range till zero.
Thanks in advance.
|