Yep I got it working! Thank you! It looks like I will have to update the formulas weekly because I need the cells empty in order for the dynamic part of the chart to work.

Is it possible to write a macro to do the updating? or does that get pretty complicated?