Update chart data with VBA

Hi guys,

I have the following problem (please see the attached file) - i have built a 3-D chart from a source data containing entries for the last 4 quarters by program. For the new quarter, I want to insert a new column into the table and have the chart automatically capture the 4 most recent quarters. Is there a way to set the source data reference in VBA so that it does not change (i.e., always captures data from the same columns based on their names - columns A:E in my example)?
Ideally, this will happen when the chart worksheet gets activated.


Thanks a lot!!

D.