dynamic end on chart
 

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.

Adapt the ideas at Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
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.