View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] samienisarioglu@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.