Suppress graph if no data in cells

Discuss the spreadsheet application
Post Reply
sharon23
Posts: 1
Joined: Fri Sep 13, 2019 9:27 am

Suppress graph if no data in cells

Post 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
OpenOffice 4 on Windows 8.1
User avatar
Zizi64
Volunteer
Posts: 11360
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Suppress graph if no data in cells

Post 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
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply