DYnamic Charts with two options

[jontyoc]

Hi All

I have a selection of data that I want to create scatter chart with a smooth line graph for.
They are grouped by account type and day of the week.

I have a total of 15 accounts and 5 working days.
I have looked on google and here in MrExcel and found that I need to create a dynamic chart from a drop down list. But I am not sure how I would alter this to be able to choose as I wish.

Here is an example:
ACT1 sits in A2, and the figures start in c3 to V7 for all days of the week.
ACT2 would start at A9, and ACT3 start at A16 and so on.

ACT 1
Mon -0.5 -1.2 -2.1 -3.7 -2.9 -6.8 -8.2 -6.1 -4.2 -2.1 -3.4 -2.3 -3.5 -4.1
Tues -1.6 -2.4 -3.6 -8.6 -3.6 -4.0 -4.7 -3.7 -4.4 -6.5 -3.1 -2.9 -4.9 -3.9
Weds -1.0 -0.6 -0.9 -1.5 -2.8 -3.5 -10.6 -4.7 -7.7 -9.2 -4.3 -1.9 -2.5 -4.5
Thurs -1.5 -0.2 -0.3 -0.8 -1.7 -5.4 -5.6 -3.8 -3.0 -3.2 -4.7 -4.8 -3.8 -1.7
Fri -1.2 -0.2 -2.3 -2.0 -3.3 -4.7 -5.6 -7.1 -3.1 -2.1 -2.4 -2.6 -4.5 -5.5



Any help would be greatly appreciated. I would rather do this that have a drop down list with Account 1 Monday, Acount1 Tuesday and so on, just to make the list smaller and more manageable.
Hope this makes sense.
Thank you for helping.

 

[oldbrewer]

do you want a chart for each day or is the data to be combined ?

 

[jontyoc]

I would need a chart for each day.

 

[oldbrewer]

col A	row 1
act1												day of week table
mon	3	1	4	5
tue	5	4	5	6								mon	1
wed	4	6	8	7								tue	2
												wed	3
												thu	4
act2												fri	5
mon	9	7	7	9
tue	8	4	5	6								(I called it mytable)
wed	7	3	5	8
			chart required for	act2
				day	tue
			day of week	2
					1	2	3	4
				row 27	8	4	5	6
			if you change the selections the data will update so it is truly dynamic
			make your chart from this data
			formula giving the first 8
			=OFFSET($A$1,MATCH($F$16,$A$2:$A$11,0)+$F$18,F26)
			f16 is the cell with act2 selected in it

<tbody>
</tbody>