use cell values as index?

[aysu]

hello all,

i am not sure how to search for it, so i am sorry if this post is a duplicate of an older one.

assume in column A, B, and C i have numbers (from A1 to A100 in column A, from B1 to B3 in column B, and from C1 to C3 in column C).

i have a line chart, which has 4 series on it.

the [i]th series values should start with A[B[i]] and end with A[C[i]] (a programming language syntax). For instance, I tried to set the first series values as =$A$B1:$A$C1 but it bumped how can I do that?

any help or direction is appreciated)

[FDibbins]

=$A$B1:$A$C1 not a recognosed function/format, nor even a range/array for excel. im also not familiar with your syntax of A[C[i]], if you are trying to run a calculation, what is it supposed to be doing?

[aysu]

let me clarify the problem with an example. assume the contents in column B are 1 21 51 81, and column C are 20 50 80 and 100. and there are numbers in column A from A1 to A100.

so the 1st series should have the values from A1 (1 comes from B1) to A20 (20 comes from C1),
the 2nd series should have the values from A21 (21 comes from B1) to A50 (50 comes from C1), ...

if i had just one graph, i would type them myself but i have 24 of them and it would be too easy if i can automate it somehow