Selecting a range works fine, but when I enter
offset($Sheet1.$D$3,0,0,$Sheet1.$H$1,1) for the data range, the "Ok" button greys out. I thought this was possible, but it doesn't seem to work? Can Calc do something like this, with dynamic number of data in a chart?
Thank you for the response, I'm looking for 1) the link to the bug that describes Calc's inability to use a function for the range, 2) description of a workaround.