Referencing Chart Data?
in [Programming]
|
Prev: code for Allow Insert Hyperlink
Next: Convert date (m/dd/yyyy) in text format into an excel recognised date
From: Doug on 11 Mar 2010 14:12 I have a chart that is referencing a series of data that are formulas. The formulas return an average for the specified array. I am needing to find out how to keep the chart from considering the blank cells as zero values. I have tried having the formula return a "" (blank) value if false, but it still shows up in the chart as a zero value. Do you know the answer to this? -- Thank you!
From: ker_01 on 11 Mar 2010 17:06
I don't know if this varies by version of Excel, so I'll just respond with what works in 2003: If you don't mind a continuous graph, try returning the N/A value by using NA() if(x=true, x*14, na()) HTH, Keith "Doug" wrote: > I have a chart that is referencing a series of data that are formulas. The > formulas return an average for the specified array. I am needing to find out > how to keep the chart from considering the blank cells as zero values. I have > tried having the formula return a "" (blank) value if false, but it still > shows up in the chart as a zero value. Do you know the answer to this? > -- > Thank you! |