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)