Hello,

I really hope that this is possible!

I have a line graph which insists upon graphing a zero value for a blank cell, which is very distracting.
The cell is truly blank, there is nothing in it.
Gaps are selected properly in the chart format.

Using NA works, however it causes this formula on another sheet to return a value of NA, which is also graphed.

=IF(SUMIFS(DailyData!$Y:$Y,DailyData!$C:$C,">"&WeeklyData!$C58,DailyData!$C:$C,"<="&C59)>0.001,AVERAGEIFS(DailyData!$Y:$Y,DailyData!$C:$C,">"&WeeklyData!$C58,DailyData!$C:$C,"<="&C59),"")

This formula takes a weekly average from the daily data, but leaves blanks for unpopulated weeks.

I realize that is not the cleanest formula, but it needed some work arounds to deal with a few issues.

So - is there a way to cause the chart to graph a gap without using the NA?

Or - is there a way to rewrite the formula above to skip any NAs I write in?

Many thanks!