Variable in excel formula

[Myyst]

Hi all,

I am wondering if it is possible to insert a variable inside an excel formula?

This particular formula comes from a graph I am trying to set up:

=SERIES(,'Stocks perf'!$AF$6:$AF$18,'Stocks perf'!$AI$6:$AI$18,1)

Is it possible to make the bold area a variable? ie:

=SERIES(,'Stocks perf'!$AF$6:$AF$18,'Stocks perf'!$AI$6:$AI$X,1)

Thank you guys!

[Fotis1991]

Perhaps this?

http://www.techrepublic.com/blog/mic...arts-in-excel/

[Myyst]

Thanks Fotis1991,

Is there no more straightforward way to do it?
Plus, this graph is going to be replicated various times in various spreadsheets so I would like to avoid Defined Names as much as possible.

[Fotis1991]

My knowledge about charts is limited!

No other ideas. Hope someone will be able to helps you more. Good luck.

[Myyst]

I was thinking about something like:

To get this result:

=SERIES(,'Stocks perf'!$AF$6:$AF$18,'Stocks perf'!$AI$6:$AI$18,1)

I use this formula:

=SERIES(,'Stocks perf'!$AF$6:$AF$18,'Stocks perf'!$AI$6:$AI$&INDIRECT($F$2),1)

Where F2 links to a cell which values equals 18.

No luck for the moment, it is not working.

[Special-K]

INDIRECT should point to a cell or range not part of a range.
Try this

=SERIES(,'Stocks perf'!$AF$6:$AF$18,INDIRECT("'Stocks perf'!$AI$6:$AI$"&$F$2),1)

[Myyst]

I get "That function is not valid" as a result :/