Help creating multiple charts from one table using macros!!

[alig114]

Hey guys, let me start off by saying that you lot, are GENIUSES. This forum has saved my *** so many times and has really helped me learn alot about excel. Today, i have a new challenge. One that I'm really not sure how to deal with. I have a dynamic set of data, loaded from a server. The columns are FIXED. I will attach a sample of how the data looks.

[TABLE="width: 836"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]site_code[/TD]
[TD] report_goup[/TD]
[TD]asm_week[/TD]
[TD]asm_year[/TD]
[TD]form_factor[/TD]
[TD]platform[/TD]
[TD]aaset_tag_qty[/TD]
[TD]fp_pass_qty[/TD]
[TD]fp_fail_qty[/TD]
[TD]FPY[/TD]
[/TR]
[TR]
[TD]NL[/TD]
[TD]BATTERY-BOX-ASSY[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2013[/TD]
[TD]BATTERY-BOX[/TD]
[TD]PACK[/TD]
[TD="align: right"]564[/TD]
[TD="align: right"]9422[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]0.996835[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]TRAY-ASSEMBLIES[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]2013[/TD]
[TD]ITRAY[/TD]
[TD]IKO-W[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]0.870588[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]RACK-ASSEMBLIES[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2013[/TD]
[TD]RACK-ASM[/TD]
[TD]IK-MAW[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]0.372549[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]TRAY-ASSEMBLIES[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]2013[/TD]
[TD]STRAY[/TD]
[TD]HINGEBOOK[/TD]
[TD="align: right"]320[/TD]
[TD="align: right"]294[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]0.91875[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]TRAY-ASSEMBLIES[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]2013[/TD]
[TD]STRAY[/TD]
[TD]HINGBOOK[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.955556[/TD]
[/TR]
</tbody>[/TABLE]


I don't know how to attatch a file here, but the first row is the title row, under it are the values. The columns here are fixed. What i NEED to do, is somehow create something that will make a seperate graph for every different PLATFORM , showing the FPY chaging over time. Time here is the weeks which will always be a rolling 12 weeks. I'm thinking that i need to use MACROS to do this, but i'm not sure where to start. If someone could help me out, point me in the right direction, it would be MUCH appreciated.

Thanks so much guys

 

[alig114]

EDIT: I forgot to mention that for a given PLATFORM, there can be two different types, one for each FORM FACTOR. FOR example, the HINGEBOOK platform can have an STRAY form_factor and a ITRAY form factor, for those i would need different charts

 

[alig114]

Ah i also forgot to tell you guys, this data is dynamic. So certain platforms can be added or removed, I want to figure something out that will work around that. Sorry for being so n00b guys, I know how to make all these charts and graphs statically, but I've never had to deal with dynamic data like this, so any help would be appreciated.