Add formula within reference to a cell "A(x+y)"

**daolo** · 10-10-2012, 08:45 AM

I'm building a worksheet with a diagram, and I want the users to be able to choose scale of the x-axis.

Within the diagram, the data refers to a range, let's say =$A$1:$A$10.

I want to do soemthing like =$A$1:$A$(1+B1), where B1 is a cell where the user chooses scale.

I can't refer to a cell like above, so now I'm wondering how to do it? I guess and hope there is an easy explanation, like use =$A$1:[$A$(1+B1)], but I haven't found out yet.

Thanks in advance!

**Ace_XL** · 10-10-2012, 09:04 AM

Create a dynamic named range and use that to populate your graph.

See attached. Adapt accordingly.

**daolo** · 10-10-2012, 09:14 AM

Originally Posted by Ace_XL

Create a dynamic named range and use that to populate your graph.

See attached. Adapt accordingly.

I don't get it..! Where have you refered to the B1 cell?

**Ace_XL** · 10-10-2012, 09:18 AM

There is a dynamic named range ("a") that I have created defined as

=OFFSET(Sheet1!$A$1,,,Sheet1!$B$1+1)

thsi populates teh graph.

Check here for info on named ranges
http://support.microsoft.com/kb/830287