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.
Because only cell ranges can be used, no formulas, no named ranges.
One option is use a filter to hide the data that you don't want to see in the chart.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-27 23:35:13 +0200
Seen: 166 times
Last updated: Jul 30 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
@NoBugs -- still looking for an answer? Please let us know if you're still interested in a solution here.
qubit ( 2013-03-13 11:30:43 +0200 )edit