Using BIG Table of Data in Graph

[melange]

This is my first question in this forum. I am very excited! Not sure how to word the issue, but here it goes:
The main data source
I have 22 areas and data on each of these areas by month.
The months are in Column A and the names of the areas are in the first two rows.
I have about 10 years of data = 120 rows of data
Each month, I add a new row of data for the most recent month.
What I do with it
In order to display the information, I have created graphs that I go through and update every time I add a new month's data.
I also have created additional columns to the right of the 22 columns of data to show the month over month changes as well as the year over year changes.
This last step has added to the data source by 44 new columns to the right of the original ones. These are formulas using the original static information.

[melange]

I would like to make this process more dynamic

[melange]

Maybe a pivot table?