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?
Edit -
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.