Suppress graph if no data in cells

Discuss the spreadsheet application

Suppress graph if no data in cells

Postby sharon23 » Fri Sep 13, 2019 9:31 am

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
sharon23
 
Posts: 1
Joined: Fri Sep 13, 2019 9:27 am

Re: Suppress graph if no data in cells

Postby Zizi64 » Fri Sep 13, 2019 3:26 pm

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; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.8; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8375
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: Lupp and 36 guests