Hi guys, this is my first post and I hoping someone can help me.

I have created a data spreadsheet that automatically filters out data according to if statements and index function. I am left with a basic table with a number of actual figures and some #N/A values. I have used the function =IF(A1="",NA(),A1), to return back #N/A if there are no values. As there are multiple variables in the data tables I am using I need the graphs to be able to plot a single value up to 30 values, unfortunately it keeps plotting all 30 values regardless of it being a true value or a #N/A. I have done similar graphs in the past, where this does work perfectly but for some reason it is not working now. Any help would great.