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 :

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

Leave a Reply