No data series line for 0 values in chart

  • Thread starter Thread starter KHUGHES
  • Start date Start date
K

KHUGHES

I am charting values from cells with formulas
=IF(C84="","",B66+C54+C56)

It is charting the "" as a 0 value. How do I prevent charting that lin
into the future if C84 is empty? I want the line in the chart to stop
As I have it formulated it drops to zero and tracks along the zer
line.

Thanks for any help,

K
 
Back
Top