Workaround needed to use dynamic range as source for charts

Hey guys, I've been working on an Excel spreadsheet for almost a week now. I'm not an expert at using Excel (2007), so I went through a lot of trial and error. Many solutions I applied I actually found in this forum, so that's why I'm turning to you for help now.

Intro:
I have encountered a problem yesterday, that I haven't been able to find an easy fix for. Since I have about 20 sheets in my .xlsx and they are all connected, I'll try to simplify this as much as possible. If there's anything I'm not clear on, please ask.

The goal of my spreadsheet is to create a statistic about a set of data. The data is exported from another application manually. From that data I generate a sheet with results, applying certain filters and using various types of "if" functions.

On the results sheet I have multiple columns, each containing a certain key figure used to track the progress of a project in my company. The rows contain different departments and groups which are being compared. An important part of tracking the overall progress of the project is creating trend-charts to see how the numbers are changing.

Since some of the columns contain indices (0-1) and some contain large numbers (e.g. delay of a measure in weeks), I chose to "normalize" the numbers before plotting them, so I could show them on the same graph. I do that by generating factors to apply to the data of a given column based on the highest value in that column.

Real issue:
That leaves me with a set of data structured like this:
A B C D
'empty' 'empty' date1 date2
col 1 'empty' #1.1 #1.2
col 2 'empty' #2.1 #2.2

I have almost 30 of those tables underneath each other. I have defined a name using OFFSET and COUNT for each of them.

Now I've created numerous charts, using the the defined names as sources. THE PROBLEM IS: When I enter the defined name (refering to a dynamic range), excel generates a "hard" cell reference from that name and uses this as the source for the chart. Thus, every time I add a column with new numbers to my source sheet, I have to click on each graph and enter the defined name again to let excel re-define the cell reference and include the new data in the charts.

I've unsuccessfully tried to record a macro to automatically re-enter the source names for the charts.

Any help would be GREATLY APPRECIATED!

I'd also be willing to donate to the forum or individuals who've been especially helpful.

Nick

PS: Here's a link to a dummy file I created from my file: http://db.tt/y1nt2Vui. I removed as much content as possible while still leaving enough to understand what I'm doing. The file is about 900kB in size.