Ask Your Question

Why can't I use Offset in Calc Graph Data-range? [closed]

asked 2012-07-27 23:35:13 +0200

NoBugs gravatar image

updated 2012-07-30 14:54:46 +0200

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Closed for the following reason "question is not relevant or outdated" by qubit
close date 2013-04-28 02:26:07.337036


@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

1 answer

Sort by » oldest newest most voted

answered 2012-07-28 14:54:05 +0200

mariosv gravatar image

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.

edit flag offensive delete link more


@mariosv -- Any chance you could provide a detailed description and help track down the appropriate bug # here (or file a new one?). Thanks!

qubit ( 2013-01-29 11:23:30 +0200 )edit


Asked: 2012-07-27 23:35:13 +0200

Seen: 298 times

Last updated: Jul 30 '12