Why does Chart data disappear when columns are hidden?

[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!!

[Charlie Young]

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."

[Villeroy]

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

[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.