What should I do to include the empty cells in my chart? I can't find any help in the parameters...
CodePudding user response:
there is no such option. you would need to feed it from helper formula:
=INDEX(FLATTEN(IF(A2:B11="", "vider", A2:B11)))
What should I do to include the empty cells in my chart? I can't find any help in the parameters...
CodePudding user response:
there is no such option. you would need to feed it from helper formula:
=INDEX(FLATTEN(IF(A2:B11="", "vider", A2:B11)))