Page 1 of 1
Why does Chart data disappear when columns are hidden?
Posted: Tue Oct 19, 2010 8:47 pm
by pconroy328
I have an XY Scatter plot, and decided to hide the columns with the data.
As soon as I hide them - the Chart clears, the data points disappear?
Is this supposed to happen?
If so - I fail to understand why that would be desired?
OpenOffice 3.2.1 OOO320m18 Build 9502
thanks!!
Re: Why does Chart data disappear when columns are hidden?
Posted: Tue Oct 19, 2010 10:12 pm
by Charlie Young
pconroy328 wrote:I have an XY Scatter plot, and decided to hide the columns with the data.
As soon as I hide them - the Chart clears, the data points disappear?
Is this supposed to happen?
If so - I fail to understand why that would be desired?
OpenOffice 3.2.1 OOO320m18 Build 9502
thanks!!
It's a default option. Under Format > Data Series, check "Include values from hidden cells."
Re: Why does Chart data disappear when columns are hidden?
Posted: Tue Oct 19, 2010 10:53 pm
by Villeroy
pconroy328 wrote:
Is this supposed to happen?
If so - I fail to understand why that would be desired?
Because too many users complained.
http://qa.openoffice.org/issues/show_bug.cgi?id=91578
http://qa.openoffice.org/issues/show_bug.cgi?id=81209
Re: Why does Chart data disappear when columns are hidden?
Posted: Wed Oct 20, 2010 12:49 am
by acknak
Note that the resolution there was to give users the option whether or not to display values from hidden cells.
Getting the option set for a hidden data set is a bit of a nuisance, but the option is there.