Help to make drop down list chart

[keikolv]

Hi!,Help to make drop down list chart. I want make drop down list like:
option 1
t1
t2
t3
t4
option 2
t1
t2
t3
t4
How to make graph to choose only option 1 and option 2, when I make drop down button i have included blank cells.
I want to make choose between option 1 and option 2 but with t1,t2,t3,t4 graph in single chart graph.

[mgd0903]

I saw another post similar to this yesterday so I am assuming this is a homework assignment. Remember their is a code of ethic you should follow. However I see you have made some attempt to solve the problem, so I will attempt to guide you without explicitly giving you the solution.
(1)Review the syntax of the INDEX function, you will notice it has an array and a reference syntax. Consider using the reference syntax.
(2) The reference may be a contiguous or non-contiguous range.
(3) The drop down box is used to manipulate one parameter of the Index function.
(4) Where you have the chart data consider making a,b,c,d, t1,t2,t3,t4 static values:
(5) The chart data area will have the same index formula but the parameters are dynamic
(6) Hint: How to generate a series 1,2,3,4,5 for the row and column indices? For rows use =Row($A1:$A$5) and then drag across and down, for columns you figure it out.

Now go and solve, you have enough knowledge to figure it out.

[keikolv]

i don't get it.

[keikolv]

it's not homework.I dont daily work with excel.

[mgd0903]

See if this is what you are trying to achieve.
If it is please mark as Solved.

[keikolv]

Tnx man!