Creating Charts from List Using VBA Loop

[TxNyCa]

I am trying to create a VBA loop to build line graphs. I want the loop to look at a reference tab and create each graph on a new named tab accordingly to my list. I have pasted my code below (I am VBA novice--this is what I have been able to string together via MANY web searches). I have attached a dummy file, including what I want the graphs to look like.

Please Login or Register  to view this content.

[Tinbendr]

I'm not sure if I have the formula right.

I had to change the Font name as I didn't have the one in the code installed.

Please Login or Register  to view this content.

[TxNyCa]

Thank you!! I really appreciate your help.