English
Ask Your Question
0

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 qubit
close date 2013-04-28 02:26:07.337036

Comments

@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
0

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

Comments

@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

Stats

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

Seen: 311 times

Last updated: Jul 30 '12