Excel VBA to Update Chart Source Data

I need help creating the VBA to set the source data for a graph I have created. The data range for this graph changes based on a pivot table and so I need the source data to change dynamically when the data is filtered. I have identified code that will give me the correct source data range:

Please Login or Register  to view this content.

Now I need the code that will actually use this range to update the graphs source data. I have attached a sample file. Unfortunately I cannot use dynamic named ranges since all of the series do not have data points for the dates on the x-axis. Also I cannot use a PivotChart because I need this file to be compatible with Excel 2011 for Mac, which does not support Pivot Charts. Any help you can provide with this is greatly appreicated. Thanks!

Here is sample file