Problem with dynamic charts
Im trying to use a dymanic chart and I am using an If then formula for the
data. My false data = "". I thought this was equal to a blank cell but for
some reason the dynamic chart is picking it up as something and graphing
these blank cells. If I delete the cells the dynamic chart works perfectly.
Please advise as to what I need to replace the "" with in order to make the
chart work. -Thanks
|