I am trying to create a graph using data from my table, now some of my data
has blank cells, however they are blank because the formula i am using tells
it to be blank, i.e. if (a4<10,"",a4). however when i graph this data it
graphs it as a zero value. Is there a way to omit this data from my graph,
i have already tried going to the chart option table and selecting plot empty
cells as NOT PLOTTED but i think that only applies is there is no formula in
the cells. can someone please help me out, or at least point me in the right
direction.