'How can I Include empty cells in my chart?

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



Solution 1:[1]

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0