I working with a dynamic graph that uses the following formula to define the X-Axis ("Fast" is the name of a specific sheet within the book). The dataset the formula is looking at will frequently have either no data or "0" as the value. I would like to edit this formula such that the graph does not plot anything if one of these condition is present. I have seen solutions recommending the use of NA(), but I cannot figure out how to change my formula. Can anyone help?
[=OFFSET(Fast!$A$1,1,0,COUNTA(Fast!$A:$A))]
Thanks in advance for your time! Tisha
Bookmarks