Home > Net >  How can I Include empty cells in my chart?
How can I Include empty cells in my chart?

Time:04-08

What should I do to include the empty cells in my chart? I can't find any help in the parameters...

enter image description here

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)))

enter image description here

  • Related