Ask Your Question

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

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

NoBugs gravatar image

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

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 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 gravatar imagequbit ( 2013-03-13 11:30:43 +0100 )edit

1 Answer

Sort by » oldest newest most voted

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

m.a.riosv 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 gravatar imagequbit ( 2013-01-29 11:23:30 +0100 )edit

Question Tools


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

Seen: 545 times

Last updated: Jul 30 '12