Dynamic Graph Help

[Lewzerrrr]

Hi,

I have a table that isn't in the best format but this can't be changed.

It looks something like the below..

	201701	201702	201703
Department	F	L	M	F	L	M	F	L	M
Dept 1	61	71	63	53	87	50	63	74	19
Dept 2	87	46	75	21	70	50	26	37	41
Dept 3	75	68	12	55	2	88	34	4	55
Dept 4	90	39	30	25	20	50	60	19	65
Dept 5	5	88	15	66	18	14	77	83	48
Dept 6	23	80	6	10	33	78	24	56	50
Dept 7	88	31	37	41	49	61	58	78	72

<colgroup><col><col span="9"></colgroup><tbody>
</tbody>

I want to pull a graph off this where I can use a drop down of F/L/M and look only at the sales of that letter.

I think you can use a named range that selects the data of the letter but unsure what the formula would be.

Thanks,

 

[Worf]

Hi

Would you accept a VBA solution?