I have data from jan 04 through present and each month new data is added to
30 different Areas
I have a line chart for each Area (data on an excel spreadsheet) that needs
to be updated for the twelve month period. (i.e. if i just got april data the
chart needs to reflect may 04 - april 05 and this needs to be done on 30
different charts. I manually change the data points for each of these graphs.

Is there an easier way to update these charts with a new data series without
manually going into each chart and changing the data source?