I have to update dozens of charts every day with the previous day's stats.
The new data is always added to the next column on the right. Is there a way
to tell my chart to get all data even though the number of columns changes
every day?

Example:
Yesterday I had data through column AD.
Today I add data for column AE and revise the chart to get that data.
What I've tried doing is telling the chart to get data through column BZ.
This works but then the right side of my column chart is empty because I
don't have data yet. I want the chart full size all the time.
Possible?

Thanks wiz kids.