Reference problem with chart when offset and count reduces the max columns to less

[Peter Davison]

I have the cells below all formulas.
I've used the following named range - =OFFSET($DA$7,0,0,COUNTA($DA$7:$DA$100),MAX(DB5:DK5)+1)
The chart displays correct and file saves okay
Once the number of clusters data changes to less than 10 columns (Second Picture Below 6 clusters), the chart still displays correctly but when the file is saved the reference error message appears. (Below)
I know it must be something to do with the formulas in the blank cells, because if I delete the formulas from the clusters 7 to 10 the problem goes away.

Any help would be really appreciated.

This is the formula in each of the Cluster 1 to 10 cells for rows 8 to 100 (A bit of a long one I know)

=IFERROR(IF(OR($DA8="",DB$5=""),"",
(SUMIFS($Z$7:$Z$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)/SUMIFS($Z$7:$Z$4998,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)*$Z$3+
SUMIFS($AA$7:$AA$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)/SUMIFS($AA$7:$AA$4998,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)*$AA$3+
SUMIFS($AB$7:$AB$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)/SUMIFS($AB$7:$AB$4998,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)*$AB$3+
SUMIFS($AC$7:$AC$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)/SUMIFS($AC$7:$AC$4998,INDEX($A$7:$BR$4998,,MATCH($DA$5,$A$7:$BR$7,0)),"="&DB$5)*$AC$3)/
(SUMIFS($Z$7:$Z$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8)/SUM($Z$7:$Z$4998)*$Z$3+
SUMIFS($AA$7:$AA$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8)/SUM($AA$7:$AA$4998)*$AA$3+
SUMIFS($AB$7:$AB$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8)/SUM($AB$7:$AB$4998)*$AB$3+
SUMIFS($AC$7:$AC$4998,INDEX($A$7:$BR$4998,,MATCH($DA$6,$A$7:$BR$7,0)),"="&$DA8)/SUM($AC$7:$AC$4998)*$AC$3)*100),"")