First time here? Check out the FAQ!
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.
answered 2012-07-28 14:54:05 +0200mariosv
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