Charts - how to limit x-axis to rows with populated values

[MCunningham]

[edit] SOLVED BY STEVE=TRUE (summary on my next post)
I have a lot of charts that I publish every week for budget meetings. The chart range for the first one is 'Hist Table'!$A$1:$R$100
The A column is a list of fiscal weeks (FY13-P2-W2, FY13-P2-W3, etc) and the rest of the columns make up the y-values. They are set to be "" (blank) in their formulas if there is no data matching that week.

What I would like to do is leave the chart range for the entire range through the end of the year, and have the x-axis only stretch up to the current week (for which there is data). Instead, I either have to have a big blank on the right side of the chart or keep updating the range for every chart every week.

Is there a solution to this? Thanks so much in advance!