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..

[TABLE="width: 658"]
<colgroup><col><col span="9"></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 3"]201701[/TD]
[TD="colspan: 3"]201702[/TD]
[TD="colspan: 3"]201703[/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD]F[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]F[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]F[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]Dept 1[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD]Dept 2[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]41[/TD]
[/TR]
[TR]
[TD]Dept 3[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD]Dept 4[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD]Dept 5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Dept 6[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Dept 7[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]72[/TD]
[/TR]
</tbody>[/TABLE]

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?