Page 1 of 1

Suppress graph if no data in cells

PostPosted: Fri Sep 13, 2019 9:31 am
by sharon23
Hi my data range for graph y-values are a1 to a100
But cells a20 to a100 are curently empty.
is there anyway that graph will not show empty cells until cell has a value ?
thanks
sharon

Re: Suppress graph if no data in cells

PostPosted: Fri Sep 13, 2019 3:26 pm
by Zizi64
is there anyway that graph will not show empty cells until cell has a value ?

Yes, there is.

It is a LibreOffice 6.1.6 sample:

chart gap.jpg