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!